PDA

Click to See Complete Forum and Search --> : Access not support UNICODE character?

forester
May 8th, 2009, 01:14 AM
It looks like that Access database doesn't support Unicode character, then it's impossible to input unicode characters such as characters of east asian languages, isn't it? Thanks!


Following is part of the document from http://msdn.microsoft.com/en-us/library/ms714540(VS.85).aspx

Data type: CHAR, LONGVARCHAR, and VARCHAR

Description :
A character string literal can contain any ANSI character (1-255 decimal). Use two consecutive single quotation marks ('') to represent one single quotation mark (').

Procedures should be used to pass character data when using any special character in a character data type column.
dglienna
May 8th, 2009, 07:03 PM
Where'd you get that? ODBC SQL Data Type

LONG TEXT
LONGTEXT
SQL_LONGVARCHAR[2] SQL_WLONGVARCHAR[3]

MEMO
LONGTEXT
SQL_LONGVARCHAR[2] SQL_WLONGVARCHAR[3]

where [3] is Unicode support
forester
May 8th, 2009, 10:58 PM
Where'd you get that? ODBC SQL Data Type



where [3] is Unicode support
Thank you dglienna.

However SQL_WLONGVARCHAR[3] is ODBC SQL Data Type, not MS Access data type.


Data type: CHAR, LONGVARCHAR, and VARCHAR

Description :
A character string literal can contain any ANSI character (1-255 decimal). Use two consecutive single quotation marks ('') to represent one single quotation mark (').


Above is from this link : http://msdn.microsoft.com/en-us/library/ms714540(VS.85).aspx
dglienna
May 8th, 2009, 11:20 PM
search for "[3] Unicode and Access " and then scroll UP