How to store Big5 Chinese in mysql using VB.Net?

[victor Mui]

My Mysql table is created as follow

create table 't_goodsinfo' ('ID' varchar(20) Not Null default '', 'Name' varchar(40) Not Null default '', Primary Key ('ID')) Engine = MyISAM Default Charset=latin1;

I want to store Big5 Chinese into the above table using VB.net datagrid through the mysql .net connector 5.0

I have tried to set the [mysql] default-character-set=big5 in my.ini.
But no luck, it doesn't work. The chinese character in db show '??' (it should show '中文') and it also show '??' in vb.net datagrid too.

If I set the [mysqld] default-character-set=big5 in my.ini, it help me to save and display the chinese in db correctly, but it will change the charset of my table to big5 and reduce the field size to half automatically which i do not want as follow.

create table 't_goodsinfo' ('ID' varchar(10) Not Null default '', 'Name' varchar(20) Not Null default '', Primary Key ('ID')) Engine = MyISAM Default Charset=big5;


Is there a way for my to save chinese character in mysql throught vb.net???

Please really help.........

P.S. The mysql table is created by mysql 4.0.26 and I need to use the table in 4.0.26 server again, so I cannot modify the table's structure.

Victor



Edited 2 time(s). Last edit at 07/01/2007 10:17PM by victor Mui.