Steps to change mysql character set to UTF8 under Linux system

Change MySQL character encoding to UTF8 on Linux

I installed the MySQL service on Linux. During the later use, I suddenly found that some fields could not be in Chinese when inserting records. The error message was as follows:

mysql> insert into syudent values(1,'陶盼',21);
ERROR 1366 (HY000): Incorrect string value: '\xE9\x99\xB6\xE7\x9B\xBC' for column 'name' at row 1

After my persistent search for information, I finally solved the problem. Here I share with you my solution:

1. Check the MySQL status in the database:

# Check mysql statusmysql> status;
mysql> quit;

2. Modify the configuration file:

#Exit the database systemctl stop mysqld.service
#Edit the my.cnf configuration file vim /etc/my.cnf
[client] //If there is no [client] section, add it yourself default-character-set=utf8
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci

After editing the configuration file, restart the MySQL service;

systemctl start mysqld 

After the restart is successful, re-query the status of MySQL, and it will be displayed as follows:

mysql -u root -p 'your password'
mysql> status;

At this time, you can enter the database normally and insert the text segment data.

3. If it still fails, it may be due to the configuration when creating MySQL or the fact that MySQL service was not stopped in the previous step to edit the my.cnf configuration file.

Here we also need to set the character set for the table and field to utf8;

#Check the table creation processmysql> use ky15;
mysql> show create table syudent;

#Set the character set of the table to utf8
mysql> alter table table name character set utf8;
#Change the character set of the field where you want to insert Chinese characters to utf8
mysql> alter table table namechange name name char(20) character set utf8;
#View the character set of the table and the character set of the fieldmysql> show create table syudent;

#Test, insert Chinese mysql> insert into syudent values(1,'陶盼',21);
mysql> insert into syudent values(2,'王旭',21);
mysql> select * from syudent;

This is the end of this article about the steps to change the MySQL character set to UTF8 under Linux. For more relevant content about changing the MySQL character set in Linux, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!