Thai charset is problem with Sybase and MS Access 2003

[Rakchat Suktum]

I've some problem when I connected to Sybase with ODBC and make a link table
in MS Access 2003, Thai charset is not displayed correctly but It works in MS
Access 97. Can anyone help me??

 

[Arvin Meyer [MVP]]

It should be the other way around. Access 97 only has single bit ASCII
characters, while Access 2000 and later have double-bit Unicode characters.
Make sure that your machine is capable of handling Unicode.

 

[Sylvain Lafontaine]

It's because you didn't use Unicode 16 bit on Sybase by using fields of type
unichar, univarchar and unitext. You Thai text is all mixed-up by Access97
when it is written but it can display correctly because Access97 mix it
again when reading it.

However, Access 2003 display it as it has been written and therefore, show
you the garbage written by Access 97.

Quite probably, you will be able to solve your problem if you switch to
Unicode on the Sybase server; however, I don't know Sybase so I cannot help
you more on this.

If you are already using Unicode on Sybase, then I don't know.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)