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!