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
Chinese charactor problem on MySQL4.1
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. ^_^
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. ^_^