DataBase - Thai charset is problem with Sybase and MS Access 2003

Asked By Rakchat Suktum

26-Jan-10 02:41 AM

I have 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??

26-Jan-10 07:46 AM

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

26-Jan-10 11:18 AM

it is because you did not 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 do not know Sybase so I cannot help
you more on this.

If you are already using Unicode on Sybase, then I do not 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)