设定数据库字符集 mysql
alter database da_name default character set 'charset'
Server characterset: latin1_swedish_ci
改成Server characterset: gb2312
创建数据库的时候用
CREATE DATABASE `mydatabase` DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
show variables like 'char%';
在my.ini中加下面两句:
[mysqld]
default-character-set=gbk
[client]
default-character-set=gbk
记得重启数据库
问题暂时解决了,在每次处理中文字时都使用
SET character_set_client = gb2312;
Server characterset: latin1_swedish_ci
改成Server characterset: gb2312
创建数据库的时候用
CREATE DATABASE `mydatabase` DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
SET character_set_connection = gb2312;
SET character_set_results = gb2312;
这样就可以了,但每次重启时,又要重新设定,有什么办法解决吗?
myConnection.ConnectionString = "Persist Security Info=False;database=myDB;server=myHost;Connect Timeout=30;user id=myUser;pwd=myPass;charset=latin1";