Chinese charactor problem on MySQL4.1

Chinese charactor problem on MySQL4.1

Postby Gary » Mon 20 Dec 2004 08:35

Hi

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.

Gary
Gary
 

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


Return to dotConnect for MySQL