3.MYSQL Display Chinese garbled solution under DOS control

MySQL client used to use, suddenly turn to DOS command, there will be some less adapt to the data in the database display may have problems "Chinese display garbled"

Have encountered this problem before, today solved a ah, MySQL database is not supported by default in Chinese. So you need to change the default encoding to gb2312 "UTF8 sometimes does not support Chinese).

The following configurations are possible:

First, go to the MySQL installation directory, locate the My.ini file, find
[Client]
port=3306
[MySQL]
default-character-set=gb2312
Set Default-character-set to gb2312, this setting is to set the client, Default-character-set indicates that the character encoding we entered is gb2312 format.

Second, and then found in the My.ini file
# created and no character set is defined
default-character-set=gb2312
Set the Default-character-set to gb2312, which is the MySQL database setting, Default-character-set represents the encoded form of the information we enter in the MySQL database.

Finally, restart MySQL, (turn off MySQL, and then restart.) Done

3.MYSQL Display Chinese garbled solution under DOS control