Solve the problem of garbled Chinese characters in Mysql5.7

When using MySQL 5.7, you will find that garbled characters will appear after writing Chinese characters into the database through the web terminal, but Chinese characters will be displayed normally after directly operating SQL statements to insert data in the database. How to solve this problem? The data encoding process and principles of MySQL will not be explained here. If you are interested, you can search on Baidu.

Let's solve it directly using the following operations:

1. Open the MySQL console and enter the command show variables like 'character%';

The display is as follows:

 +--------------------------+-------------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\MySQL\MySQL Server 5.0\share\charsets\ |
+--------------------------+-------------------------------------------+

2. Modify the my.ini file

 [client]

  default-character-set=utf8

  [mysqld]
  default-storage-engine=INNODB
  character-set-server=utf8
  collation-server=utf8_general_ci

3. After restarting, use the command in the first step to view it as follows:

  +--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

Also, the default character set for character_set_database and character_set_server is still latin1.

4. Enter the command: set names utf8;

After restarting, use the first step command to view:

+--------------------------+------------------------------------------------+
| Variable_name | Value |
+--------------------------+------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\wamp64\bin\mysql\mysql5.7.9\share\charsets\ |
+--------------------------+------------------------------------------------+

Except character_set_filesystem which is binary, all others are utf8.

In this way, if you set the encoding to utf8 on the web side, you can enter the database normally.

The above is the editor's introduction to solving the problem of Chinese garbled characters in Mysql5.7. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:

Solution to MySQL Chinese garbled characters problem
Summary of solutions to Chinese garbled characters in MySQL database
Summary of solutions to the problem of Chinese garbled characters in Mysql
Solution to the Chinese garbled code problem in Mac Mysql database
Mysql completely solves the problem of Chinese garbled characters (Illegal mix of collations for operation)
MySql installation steps and graphic tutorials and solutions for Chinese garbled characters
Solution to garbled characters when using UTF-8 Chinese encoding in MYSQL database
The best solution to the Mysql Chinese garbled problem
How to solve the Chinese garbled problem in mysql5
Differences among MySQL character sets GBK, GB2312, and UTF8 to solve MYSQL Chinese garbled characters
A collection of solutions to MySQL Chinese garbled characters
Summarize the causes and solutions of MySQL Chinese garbled characters, phpmyadmin garbled characters, and php garbled characters
Solution to MySQL Chinese garbled characters problem
How to completely solve the problem of Chinese garbled characters in MySQL

<<: Example of how to create and run multiple MySQL containers in Docker

>>: Vue3.0 adaptive operation of computers with different resolutions

Solution to uninstalling Python and yum in CentOs system

Solve the problem of garbled Chinese characters in Mysql5.7

Solution to uninstalling Python and yum in CentOs system

JavaScript timer to achieve seamless scrolling of pictures

MySQL multi-table join query example explanation

Solution to Vue data assignment problem

Linux automatically deletes logs and example commands from n days ago

Detailed explanation of MySQL 8.0.18 commands

Analyzing the node event loop and message queue

mysql query data from one table and insert it into another table implementation method

In-depth understanding of javascript prototype and prototype chain

What does the "a" in rgba mean? CSS RGBA Color Guide

Recommend

mysql implements importing only a specified table from the sql file of exported data

Detailed explanation of the specific use of the ENV instruction in Dockerfile

Causes and solutions for MySQL data loss

One line of code teaches you how to hide Linux processes

How to install nginx under Linux

How to write a MySQL backup script

Detailed explanation of mysql.user user table in Mysql

Summary of Ubuntu backup methods (four types)

A collection of common uses of HTML meta tags

Introduction to Linux and the most commonly used commands (easy to learn, but can solve more than 95% of the problems)

Solve the problem of docker images disappearing

Suggestions on creating business HTML emails

MySQL 5.5.56 version (binary package installation) custom installation path step record

docker compose idea CreateProcess error=2 The system cannot find the specified file

How does MySQL achieve multi-version concurrency?