When SecureCRT is connected to Linux, MySQL records Chinese garbled characters are displayed.

1. view the Linux host system Character Set echo $ LANG

En_US.UTF-8

The second ssh client character encoding is set to default by default, as long as you change to the specified UTF-8 to display Chinese on the terminal.

SecureCRT settings: (After opening a Session, you can directly set the Session top selection option (Options)-> Session Options-> Appearance (Appearance)-> character (character encoding ), select UTF-8 default font Normal font select a Chinese font new 1010pt.

3. Note 1: View mysql Character Set settings

View the mysql server Character Set system variables:
Mysql> show variables like 'character _ % ';
Mysql> show variables like 'collation % ';
The character set of the final client connection is composed:

Note 2 character set can be specified during Client Connection

Mysql -- default-character-set = utf8

Note 3 the configuration file must be restarted after the character set is specified to change the configuration file.

[Client]

Set character_set_results = utf8

[Mysql]

Set character_set_results = utf8

1 2 3 Next Page