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
Find the problem Today I am going to study the to...
I have learned some basic selectors of CSS before...
Docker official documentation: https://docs.docke...
Table of contents 1. Overview 2. Django Project 3...
Website, (100-1)% of the content is navigation 1....
Ubuntu does not allow root login by default, so t...
Table of contents 1. Add packaging command 2. Run...
Table of contents TypeScript environment construc...
Servermanager startup connection database error R...
Table of contents 1. Prototype chain inheritance ...
With a lot of CSS experience as a web designer, we...
1. I recently installed a new version of Ubuntu. ...
Table of contents 1. Introduction 2. Use 1. Diffe...
Component Basics 1 Component Reuse Components are...
1. The color of the scroll bar under xhtml In the ...