Chinese charactor problem on MySQL4.1

Chinese charactor problem on MySQL4.1

Postby 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.


Postby 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. ^_^
Posts: 2
Joined: Tue 30 Nov 2004 12:16

Return to dotConnect for MySQL