Impact of mysqlcc garbled characters on Linux

Problem description: mysqlcc is installed in Federo8 but garbled characters appear after the database is opened. However, as far as I know, mysqlcc supports GBK Simplified Chinese. This problem does not occur in windows. At first, I suspected whether it was a problem with mysql. mysql's multiple character sets can easily cause database garbled characters. To solve this problem, first check the mysql System variables to find out which encodings of the database affect us. Character_set_clientcharacter_set

Problem description: mysqlcc is installed in Federo8 but garbled characters appear after the database is opened. However, as far as I know, mysqlcc supports GBK Simplified Chinese. This problem does not occur in windows. At first, I suspected whether it was a problem with mysql. mysql's multiple character sets can easily cause database garbled characters.

To solve this problem, first check the mysql System variables to find out which encodings of the database affect us.

Character_set_client
Character_set_connection
Character_set_results

The preceding three character sets have an impact on the database browsing and query. Character_set_client: the encoding of the request sent by the client. character_set_connection connects to the database. character_set_results returns the encoding of the record set. Generally, set names 'encoding' is the set of the above three statements, but this method is not helpful to my problem.

I finally thought of the OS Operating System encoding, because I suspect that the default encoding used by mysqlcc is the operating system encoding, and the current system I use is UTF-8, therefore, no matter how mysql is set on the data browsing page, it is useless because the data browsing page cannot be directly converted to UTF-8 from gbk. Fortunately, Linux provides a multi-language encoding option. Restart the computer and select GB18030. It seems that Federo has no GBK encoding options. When you enter the system, you will find garbled characters in the Chinese name folder created in UTF-8. For example, the mysqlcc query database can be properly displayed.

Coding is really troublesome. It still takes time to practice and find out the general rules and principles. For the multi-language coding problem of mysql, it is still necessary to know what encoding is stored in data, what encoding is needed, and what encoding is used to connect to mysql in the middle. If necessary, you should carefully study the description of character sets in the manual.

There is no good recommendation for the mysql gui client in Linux. This mysqlcc is just a combination, because as an open-source project, it has been stopped by mysqlAB and will not be updated. If you have any good suggestions, you can recommend them to me.