Chinese charactor problem on MySQL4.1

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply

Chinese charactor problem on MySQL4.1

Post by Gary » Mon 20 Dec 2004 08:35


After upgraded to MySQL4.1 database (Windows version), we are failed to store chinese charactors to the database when using MySQLDirect.NET PRO.
MySQLDirect.NET PRO seems just ignore the chinese charactor, and only store english charactor into the database. Is there any solution for this problem?
We are using MS Windows2000 Server, IIS 5.0. ASP.NET.
The adaptor works fine for MySQL4.0 but failed in MySQL4.1

Thank you.


Posts: 2
Joined: Tue 30 Nov 2004 12:16

Post by c3068 » Mon 20 Dec 2004 10:02

I am using MySQL 4.1.5 (linux) , I can store chinese charactors to database.
I think you need to check default character for database and tables.

By default MySQL uses the ISO-8859-1 (Latin1) character set. To change the default set, use the following commando:
./configure --with-charset=CHARSET
CHARSET may be one of big5, cp1251, cp1257, czech, danish, dec8, dos, euc_kr, gb2312, gbk, german1, hebrew, hp8, hungarian, koi8_ru, koi8_ukr, latin1, latin2, sjis, swe7, tis620, ujis, usa7, or win1251ukr.

this paragraph I use for linux version.
I sugest you to use google serch engine you can find a lot of solution.

My english is no good, hope you know what I mean. ^_^

Post Reply