.net连接mysql数据库 中文变乱码 在线等
WJ同学 2013-03-18 01:23:56 使用vb.net连接mysql数据库,插入的数据在mysql表里是乱码,用vb.net读取出来也是乱码,按网上写的修改字符集的文章修改了下,还是没成功。。
数据库中字符如下:
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set
vb.net中代码如下:
Dim mSQLcomm As MySqlCommand = New MySqlCommand("set names gb2312", mySQLconn)
中文乱码解决不掉