Steps to change mysql character set to UTF8 under Linux system

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

insert image description here

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;

insert image description here

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;

insert image description here

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;

insert image description here

#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;

insert image description here

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

insert image description here

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:
  • Example of utf8mb4 collation in MySQL
  • MySQL encoding utf8 and utf8mb4 utf8mb4_unicode_ci and utf8mb4_general_ci
  • How to change the encoding of MySQL database to utf8mb4
  • mysql charset=utf8 do you really understand what it means
  • How to change MySQL character set utf8 to utf8mb4
  • mysql garbled characters latin1 characters converted to UTF8 details

<<:  What is HTML?

>>:  How to design and create adaptive web pages

Recommend

Implementation of Docker deployment of Nuxt.js project

Docker official documentation: https://docs.docke...

Example of downloading files with vue+django

Table of contents 1. Overview 2. Django Project 3...

100-1% of the content on the website is navigation

Website, (100-1)% of the content is navigation 1....

A brief analysis of how to set the initial value of Linux root

Ubuntu does not allow root login by default, so t...

Detailed process of Vue front-end packaging

Table of contents 1. Add packaging command 2. Run...

Detailed steps to build the TypeScript environment and deploy it to VSCode

Table of contents TypeScript environment construc...

How to solve the error of connecting to the database when ServerManager starts

Servermanager startup connection database error R...

6 inheritance methods of JS advanced ES6

Table of contents 1. Prototype chain inheritance ...

Share 5 helpful CSS selectors to enrich your CSS experience

With a lot of CSS experience as a web designer, we...

Summary of Vue component basics

Component Basics 1 Component Reuse Components are...

About scroll bar in HTML/removing scroll bar

1. The color of the scroll bar under xhtml In the ...