Displaying Chinese Characters
I am designing a website that needs to be bilingal English/Chinese. I decided to create a MySQL table to hold page contents with a field called language with values en or cn.
I have two PHP pages, one queries on all records with en and has a character set "iso-8859-1" the other queries on all records with cn and has a character set "gb2312".
I have decided to enter the data using an Access database linked to the MySQL database using MyODBC. When I enter english characters all works fine. when I enter chinese charcters, they initially display fine on my PC as chinese characters, but once the record has been entered these are replaced with ?? symbols.
The question marks appear to originate from the MySQL database because they show up in the Access database, the online chinese page and using PHP MyAdmin.
I am using asp.net + myodbc 3.51 and mysql 4.1 alpha.
As you know there is a unicode support in mysql 4.1 but unfortunately if you use odbc drivers you don't have any luck. Because MyODBC 3.51 doesn't support unicode. I think they are waiting for mysql 4.1 production release to add unicode support.