1. 查看你的mysql的字符设置
mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)
2. 之前我的character_set_server,character_set_database是latin1
可以再my.cnf中的[mysqld]中添加
character_set_server=utf8(网上有人说是添加 default-character-set=utf8,我试过后发现mysql无法启动了,不知道是不是版本的问题)