查看数据编码情况:
show variables like "%char%";
+--------------------------+---------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | Latin1 |
| character_set_system | utf8 |
+--------------------------+-------------+
其中character_set_server编码为Latin1,当插入中文时发生乱码。
解决办法:
找到server安装目录下,如:C:\Program Files (x86)\MySQL\MySQL Server 5.1
my.ini文件,打开该文件,把default-character-set属性设置成utf-8或者gbk,重启server。