安装mysql后, my.ini中
[mysql]
default-character-set默认为latin1,不支持中文,当表存储中文字符时,就会报1366-incorrect string value……错误,需修改两个地方:
1)
[mysql]
default-character-set=GBK
[mysqld]
default-character-set=GBK
2)
SHOW FULL COLUMNS FROM [tablename];
alter table [table_name] character set GBK;
alter table [table_name] modify [col_name] char(20) character set GBK;
SHOW FULL COLUMNS FROM [tablename];