How to solve the DOS window garbled problem in MySQL

The garbled code problem is as follows:

The reason for the problem is very simple. It is nothing more than a deviation between the encoding of the command line and the encoding set internally in MySQL. We right-click the properties to check the encoding of the following command line, which is GBK.

solve:

mysql> show variables like 'character%'; -- Fuzzy query global variables starting with character 

• character_set_client: The character set of the client
• character_set_connection: Character set for the connection
• character_set_results: character set of query results

The above three can be set to GBK respectively: set xxx = gbk ;

This can be done simply by: set names gbk ;

Of course, the above two steps are temporary and will still be the same next time you turn it on, so the graphical interface is really great.

So far, it's over:

Author: Tianqiao Baxia Source: https://www.cnblogs.com/summerday152/
This article has been included in Gitee: https://gitee.com/tqbx/JavaBlog
If you are interested, you can visit my personal website: https://www.hyhwky.com

The above is the details of how MySQL solves the DOS window garbled problem. For more information about MySQL DOS window garbled characters, please pay attention to other related articles on 123WORDPRESS.COM!