现象描述
插入中文后,出现Incorrect string value…的错误
mysql> show variables like ‘character%’; 查看MySQL当前编码格式。
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/ |
-
除了character_set_filesystem,character_sets_dir其他都为utf8.
-
修改Mysql的配置文件my.cnf,此文件一般在/etc/mysql文件夹下
增加下文内容:
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
- 保存退出,重启服务