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! You may also be interested in:
|
>>: How to design and create adaptive web pages
Table of contents 1. Basics 1.ref 2. toRef 3. toR...
1: Install mongodb in docker Step 1: Install mong...
What is Load Balancing Load balancing is mainly a...
This article uses examples to illustrate the usag...
In Windows operating system, the program to query...
Problem background: When using docker to deploy t...
Prerequisite: Mac, zsh installed, mysql downloade...
There is often a lack of understanding of multi-c...
Table of contents Show Me The Code Test the effec...
About the tree display of Vue, the project is use...
background: Since the company's projects seem...
This article shares a draggable login box impleme...
Preface Nginx 's built-in module supports lim...
1. Priority of multiple servers For example, if e...
Simply pull the image, create a container and run...