MYSQL-1366错误解决办法

安装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<wbr> [tablename];</wbr>

alter table [table_name] character set GBK;
alter table [table_name] modify [col_name] char(20) character set GBK;

SHOW FULL COLUMNS FROM<wbr> [tablename];<br></wbr>