MySQL uses cmd to query Chinese garbled characters and mysqlcmd to query garbled characters

MySQL uses cmd to query Chinese garbled characters and mysqlcmd to query garbled characters

When viewing the MYSQL database table, CMD finds that Chinese data cannot be inserted and the Chinese characters are garbled.

Method: Find the my. ini file in the mysql Installation File and add: default-character-set = utf8.

The modified results are as follows:

[Client]
Port = 3306
Default-character-set = utf8
[Mysql]
Default-character-set = utf8

After modification, log on to mysql through cmd: mysql-u root-p

View the encoding format: show variables like "% char % ";

Change the original encoding format of the database:

Set character_set_database = utf8;

Set character_set_server = utf8;

Set character_set_client = utf8;

Set character_set_connection = gbk;

Set character_set_results = gbk;