MySQL client Chinese garbled problem solved

Found garbled in MySQL client query:

Mysql> SELECT * from user; +----+------------+----------+------------+-----------+| ID | Nickname |   Password | first_name | last_name |+----+------------+----------+------------+-----------+|  1 | Chaoliu |    321      | Chao       | liu       | |  3 | Micro      | 123      | Bill       gates  | | 5 | HelloWorld | 123      | Hello      | world     | |  7 |??         | 123 |      ?          |?         | +----+------------+----------+------------+-----------+4 rows in Set (0.00 sec)

After searching the Internet, we find that we need to change charactor_set_results to UTF8 or gb2312 (according to the code set by the shell client)

Mysql> Show variables like ' char% ';+--------------------------+-----------------------------------------+| variable_name | Value |+--------------------------+-----------------------------------------+| character_set_client | Latin1 | | character_set_connection | Latin1 | | Character_set_database | UTF8 | | Character_set_filesystem | binary | | Character_set_results | Latin1 | | Character_set_server | UTF8 | | Character_set_system | UTF8 | | Character_sets_dir | /home/work/.jumbo/share/mysql/charsets/|+--------------------------+-----------------------------------------+ 8 rows in Set (0.00sec) MySQL> Set character_set_results=UTF8; Query OK,0 Rows Affected (0.00sec) MySQL> Show variables like ' char% ';+--------------------------+-----------------------------------------+| variable_name | Value |+--------------------------+-----------------------------------------+| character_set_client | Latin1 | | character_set_connection | Latin1 | | Character_set_database | UTF8 | | Character_set_filesystem | binary | | Character_set_results | UTF8 | | Character_set_server | UTF8 | | Character_set_system | UTF8 | | Character_sets_dir | /home/work/.jumbo/share/mysql/charsets/|+--------------------------+-----------------------------------------+ 8 rows in Set (0.01 sec)

At this time, Chinese will be able to view the normal.

Mysql> SELECT * from user; +----+------------+----------+------------+-----------+| ID | Nickname |   Password | first_name | last_name |+----+------------+----------+------------+-----------+|  1 | Chaoliu |    321      | Chao       | liu       | |  3 | Micro      | 123      | Bill       gates  | | 5 | HelloWorld | 123      | Hello      | world     | |  7 | Hello     | 123 |      zhong        | Wen       |+----+------------+----------+------------+-----------+4 rows in Set (0.00 sec)

MySQL client Chinese garbled problem solved