我用的系统是Ubuntu16.0.4
提示错误:ERROR 1366 (HY000): Incorrect string value: '\xE7\x94\xB7' for column 'gender' at row 1
解决办法:
一、#vim /etc/mysql/my.cnf 。(5.5以后系统)如下修改:
[client]
default-character-set=utf8
[mysqld]
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci
二、修改完后重启mysql(/etc/init.d/mysql stop /etc/init.d/mysql start)
三、进入数据库 mysql -u root -p
设置表的编码格式,执行;alter table ttname CONVERT TO CHARACTER SET utf8;