Inserting Chinese data into the database table reports an error "1366 (HY000): incorrect string value: '\xe5\x90\x95\xe5' for column 'name' at row 1“

abnormal

adopt insert Of SQL Statement to insert Chinese data into the database table, and an error is reported ：

mysql> INSERT INTO tb_user (name, phone, email, profession, age, gender, status, createtime) VALUES (' Lyu3 bu4 ', '17799990000', '[email protected]', ' Software Engineering ', 23, '1', '6', '2001-02-02 00:00:00');
ERROR 1366 (HY000): Incorrect string value: '\xE5\x90\x95\xE5\xB8\x83' for column 'name' at row 1

reason

In fact, there is a problem with the character set of the database , We didn't specify a character set when we created the database , Then the default character set is used , And we ask to use utf8 perhaps gbk It won't be abnormal in Chinese , And what I use here MySQL 5.7 The default character set is latin1, This character set does not support Chinese display .

Use show create database Database name ; View the character set used by the specified database ：

solve

So if we want to solve this problem , In fact, you need to modify the character set of the database or database table . It is better to modify the character set of the database , But if it is a database that has been created, its character set cannot be easily modified , Therefore, the default character set is usually specified when creating the database .

The following command is to modify the character set of the table , Let the table insert Chinese content smoothly , But the character set of the database has not changed . The command format is as follows ：

#  grammar 
alter table  Table name  convert to character set  Character set ;
#  Example , Modify the database table  tb_user  The character set of is  utf8
alter table tb_user convert to character set utf8;

Insert Chinese content again and you will succeed .

Reference material ：

• Modify character set