Solution to Chinese garbled characters when operating MySQL database in CMD

Solution to Chinese garbled characters when operating MySQL database in CMD

I searched on Baidu. . Some people say to use the chcp command to change the cmd character encoding to 65001 (utf8 character encoding), but after that, Chinese characters cannot be input at all, and the Chinese query results are still garbled.

In fact, just make sure that the encoding of the cmd client and MySQL is consistent.

But the reality is that cmd defaults to gbk (you can see gbk encoding under the Chinese operating system in cmd properties), and mySQL is generally utf8 (mine is also). I have been making a misunderstanding before and wanted to change the character encoding of cmd, but it didn't work. Netizens mentioned the client encoding problem in MySQL. I just need to tell the MySQL server the client encoding and the desired result set encoding in cmd.

Specific steps:

1. Enter cmd by pressing win+r, and then switch to the bin folder of the MySQL installation directory (or directly open My Computer to find the bin folder and enter cmd in the address bar above);

2. Enter mysql -uroot -p, and then enter the password as prompted to enter the database;

3. Set the encoding;

At this time, enter set character_set_client=gbk; to tell me the text encoding on the client side

Then enter set character_set_results=gbk; to tell MySQL the result set encoding you want to return; in the experiment, it was found that as long as the client is encoded in gbk, setting this can solve the problem of garbled characters.

There is another useful command that can achieve the effect of the above two instructions at the same time:

set charset gbk; // has the same effect as the above two.

Mission accomplished! Try inserting a Chinese field!

PS: Let’s take a look at a simple method below, which can be done with two lines of code!

mysql displays Chinese garbled characters in cmd

The default encoding of cmd is gbk;

Change the character_set_results encoding of mysql to gbk;

set character_set_results = gbk;

Summarize

The above is the solution to the Chinese garbled characters that appear when operating the MySQL database in CMD. 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:
  • MySQL character set garbled characters and solutions
  • Solution to MySQL garbled code problem under Linux
  • How to solve the problem of Chinese garbled characters when inserting table data into MySQL
  • Solve the problem of Chinese garbled characters when inserting data into MySQL by Tomcat under Linux
  • Summary of handling JDBC connection mysql garbled code exception problem
  • Detailed explanation of the solution to garbled characters when JDBC connects to MySQL to process Chinese
  • Detailed explanation of the Chinese garbled characters problem in MySQL database
  • Solution to the garbled code problem in MySQL 5.x

<<:  One command lets you understand the common parameters of the read command in the shell

>>:  CocosCreator Getting Started Tutorial: Network Communication

Recommend

Examples of using HTML list tags dl, ul, ol

Copy code The code is as follows: <!-- List ta...

Tutorial on resetting the root password of Mac MySQL

Disclaimer: This password reset method can direct...

Detailed explanation of how to use eslint in vue

Table of contents 1. Description 2. Download rela...

Use of Linux bzip2 command

1. Command Introduction bzip2 is used to compress...

Summary of MySQL logical backup and recovery testing

Table of contents 1. What kind of backup is a dat...

Html+CSS floating advertisement strip implementation

1.html part Copy code The code is as follows: <...

How to quickly modify the root password under CentOS8

Start the centos8 virtual machine and press the u...

Use Navicate to connect to MySQL on Alibaba Cloud Server

1. First enter the server's mysql to modify p...

Vue implements a shopping cart that can change the shopping quantity

This article shares with you how to use Vue to ch...

How to open ports to the outside world in Alibaba Cloud Centos7.X

In a word: if you buy a cloud server from any maj...

How to draw a vertical line between two div tags in HTML

Recently, when I was drawing an interface, I enco...

MySQL uses limit to implement paging example method

1. Basic implementation of limit In general, the ...