Mysql [Err] 1366 - Incorrect string value: '...' for column '..' at row 1

Mysql错误[Err] 1366 - Incorrect string value: '...' for column '..' at row 1产生的原因是编码问题，可按照如下思路将编码统一。

1. 在mysql安装目录下找到my.ini或my.cnf配置默认编码。

   [mysqld]
   character-set-server = utf8
   collation-server = utf8_general_ci
   [client]
   default-character-set = utf8
   [mysql]
   default-character-set = utf8

2. 重启mysql后查看编码设置

   show variables like '%char%';

   

3. 查看数据库、表、字段的编码

   #查看数据库的编码
   SHOW CREATE DATABASE <databasename>;
   #查看表的编码
   SHOW CREATE TABLE <tablename>;
   #查看字段编码
   SHOW FULL COLUMNS FROM <tablename>; 
   
   #修改数据库编码
   ALTER DATABASE <databasename> DEFAULT CHARACTER SET utf8 [COLLATE utf8_general_ci];
   #修改表默认的编码和所有字符列（CHAR,VARCHAR,TEXT）的编码
   ALTER TABLE <tablename> CONVERT TO CHARACTER SET utf8 [COLLATE utf8_general_ci];
   #只修改表的默认编码
   ALTER TABLE <tablename> DEFAULT CHARACTER SET utf8 [COLLATE utf8_general_ci]; 
   #修改单个字段的编码
   ALTER TABLE <tablename> CHANGE <fieldname> <fieldname> <fieldtype> CHARACTER SET utf8 [COLLATE utf8_general_ci];