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:
|
<<: One command lets you understand the common parameters of the read command in the shell
>>: CocosCreator Getting Started Tutorial: Network Communication
Original address: http://www.webdesignfromscratch...
Everyone knows that images on web pages are genera...
When you log in to MySQL remotely, the account yo...
1|0MySQL (MariaDB) 1|11. Description MariaDB data...
This article attempts to write a demo to simulate...
Preface lvm (Logical Volume Manager) logical volu...
Preface Because the mini program upload requires ...
This article shares the specific code of js to im...
LocalStorage stores Boolean values Today, when I ...
If you want to understand React Router, you shoul...
Table of contents 1. Some concepts of Tomcat –1, ...
css3 background image related Compatibility: IE9+...
Today I got familiar with the mouse zooming effect...
1. Download 1. Download the installation package ...
Docker Features 1) Quick to get started It only t...