MS SQL Server ODBC - Retrieving multibyte characters

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Retrieving multibyte characters

Chris R G

2006-02-17, 7:23 am

I have a table that contains ascii, japanese, arabic and accented characters.
When I try and rerieve those strings using the windows odbc driver, the ascii
and since byte utf8 characters come back fine, the arabic and japanese are
returning as single byte characters. I read on microsofts page that odbc
versions before 3.7 are considered non-unicode. When I look at the version of
the odbc administrator it says 3.5. Is there a newer version of the sqlserver
odbc driver or windows odbc administrator that I would need?

Is there some way to specify what the client charset is? I'm using
SQLGetData with a target type of SQL_C_WCHAR.

Right now I have xp SP2 that has mdac 2.8 SP1.

Thanks for your help.

Sponsored Links