MySQL ERROR 1366 (HY000) Incorrect string value

The following two tables are available:

  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)  

Inserting the data times into the table is wrong:

mysql> insert into press(name) values    -> (‘北京工业地雷出版社‘),    -> (‘人民音乐不好听出版社‘),    -> (‘知识产权没有用出版社‘)    -> ;ERROR 1366 (HY000): Incorrect string value: ‘\xE5\x8C\x97\xE4\xBA\xAC...‘ for column ‘name‘ at row 1

Chinese is not supported, see the following character encoding:

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)

found that the character encoding of database is latin1, modified character encoding:

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)

Now that looks like a change, insert the data now:

mysql> insert into press(name) values    -> (‘北京工业地雷出版社‘),    -> (‘人民音乐不好听出版社‘),    -> (‘知识产权没有用出版社‘)    -> ;ERROR 1366 (HY000): Incorrect string value: ‘\xE5\x8C\x97\xE4\xBA\xAC...‘ for column ‘name‘ at row 1

Find or error, the most direct way is to delete the library!!!!!

MySQL ERROR 1366 (HY000) Incorrect string value