mysql hy000 incorrect string value_MySQL ERROR 1366(HY000) Incorrect string value

有以下两张表：

mysql> show tables;

+---------------+

| Tables_in_old |

+---------------+

| book |

| press |

+---------------+

2 rows in set (0.00 sec)

mysql> desc book;

+----------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+----------+-------------+------+-----+---------+-------+

| id | int(11) | NO | PRI | NULL | |

| name | varchar(10) | YES | UNI | NULL | |

| press_id | int(11) | YES | | NULL | |

+----------+-------------+------+-----+---------+-------+

3 rows in set (0.00 sec)

mysql> desc press;

+-------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+

| id | int(11) | NO | PRI | NULL | |

| name | varchar(10) | YES | UNI | NULL | |

+-------+-------------+------+-----+---------+-------+

2 rows in set (0.00 sec)

在往表里插数据时报错了：

mysql> insert into press(name) values

-> ('北京工业地雷出版社'),

-> ('人民音乐不好听出版社'),

-> ('知识产权没有用出版社')

-> ;

ERROR 1366 (HY000): Incorrect string value: '\xE5\x8C\x97\xE4\xBA\xAC...' for column 'name' at row 1

不支持中文，查看下字符编码：

mysql> show variables like 'character%';

+--------------------------+----------------------------+

| Variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | latin1 |

| 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.00 sec)

发现database的字符编码是latin1，修改字符编码：

mysql> SET CHARACTER_SET_DATABASE=utf8;

Query OK, 0 rows affected, 1 warning (0.00 sec)

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.00 sec)

现在看起来修改过来了，现在插入数据：

mysql> insert into press(name) values

-> ('北京工业地雷出版社'),

-> ('人民音乐不好听出版社'),

-> ('知识产权没有用出版社')

-> ;

ERROR 1366 (HY000): Incorrect string value: '\xE5\x8C\x97\xE4\xBA\xAC...' for column 'name' at row 1

发现还是报错，最直接的办法是删库跑路！！！！

不过需要查看当前库的字符编码，然后修改。