MySQL command line garbled characters

Chinese garbled characters in the MySQL command line:

Cause of garbled characters: Chinese operating system command lineProgramThe default language is simplified Chinese, encoded as GBK. The database encoding for UTF-8, so the Chinese will be garbled.

Solution:

• There are many online methods for modifying the code of the command line program, but none of them are successful.
• Modifying the database encoding has serious consequences. It may cause garbled Chinese data and has not been tried.
• Recommendation: Navicat navigation cat-the world's most powerful MySQL database management tool,Procedure-- Open database -- tool -- command line interface or F6--OK. Non-commercial version (free) download
• Not recommended: You have to set it every time you start it. You do not know how to set it permanently.Procedure-- Show variables like '% character %' -- set character_set_results = GBK;