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

MySQL configuration master-slave server (one master and multiple slaves)

Solve the problem of garbled Chinese characters in Mysql5.7

MySQL configuration master-slave server (one master and multiple slaves)

Several ways to implement inheritance in JavaScript

JavaScript canvas implements moving the ball following the mouse

MySQL knowledge points and commonly used MYSQL commands for the second-level computer exam

Web Design Tutorial (2): On Imitation and Plagiarism

Why MySQL can ignore time zone issues when using timestamp?

Pure CSS3 mind map style example

Super detailed steps to install zabbix3.0 on centos7

Customize the style of the <input type="file"> element used when uploading files in HTML

JavaScript data type conversion example (converting other types to strings, numeric types, and Boolean types)

Recommend

Zen coding for editplus example code description

Detailed explanation of CSS margin collapsing

Setting the engine MyISAM/InnoDB when creating a data table in MySQL

Brief analysis of MySQL union and union all

Detailed tutorial on installing mysql under Linux

IIS 7.5 uses URL Rewrite module to achieve web page redirection

HTML uses the title attribute to display text when the mouse hovers

Windows Server 2016 Remote Desktop Services Configuration and License Activation (2 Users)

Should I use Bootstrap or jQuery Mobile for mobile web wap

Solution to the problem that the InnoDB engine is disabled when MySQL is started

Diagram of the process from uninstallation to installation of MySQL 5.7.18 yum under Linux

How to set up automatic daily database backup in Linux

Bugs encountered when using mybatis-generator with mysql8.0.3 in IDEA

Detailed explanation of HTML basics (Part 1)

How to use lodop print control in Vue to achieve browser compatible printing