Solution to ERROR 1366 when entering Chinese in MySQL

The following error occurs when entering Chinese in MySQL:

ERROR 1366: 1366: Incorrect string value: '\xE6\xB0\xB4\xE7\x94\xB5...' for column 'introduce' at row 1

This is because of mysql encoding problem

Open mysql

mysql -u root -p

After entering the password, enter the following line of code to display the encoding currently used by MySQL:

SHOW VARIABLES LIKE 'character%'; 

From above

As can be seen from the figure, the character sets of the database and server use the latin1 encoding method. The latin1 encoding does not support Chinese, so errors will occur when storing Chinese.

Solution: Modify /etc/mysql/my.cnf (this is the default installation path of mysql)
After opening my.cnf, add the following lines of code under [mysqld] in the file:

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

Save and exit.

Restart mysql service

service mysql restart

Now delete the problematic table in MySQL and rebuild it to solve the problem.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.