察看数据库的字符集是否为utf-8.
SHOW STATUS
mysql -uroot
use YOUR DATABASE
status
----------------------------------
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 53 sec
----------------------------------
如果 client 为utf8 , 改为:
set char set 'gbk';
再试insert语句