Mysql client data garbled
Garbled characters appear when inserting Chinese data into mysql:
Mysql> select * from test; + ------ + ----------- + | id | name | + ------ + ----------- + | 1 | why are there too many connections? | 2 | why does one fail? | 3 | why does one fail? | 4 | too many threads? | 5 | too many rows | 6 | too many rows? | 1 | demo1 | 2 | demo2 | 3 | demo3 |
+ ------ + ----------- +
However, real data can be normally stored in applications.
1 Li Xiaofeng 2 Wang Xiaofeng 3 Xiao Xue 4 Wang Xuefeng 5 Lu Yun 6 peach blossom female 1demo12demo23demo3
To display Chinese characters normally on the client, you can modify the sequence set as follows:
Enter show variables like 'Char % ';
mysql> show variables like 'char%';+--------------------------+-----------------------------+| Variable_name | Value |+--------------------------+-----------------------------+| character_set_client | utf8 || character_set_connection | gbk || character_set_database | gbk || character_set_filesystem | binary || character_set_results | utf8 || character_set_server | gbk || character_set_system | utf8 || character_sets_dir | D:\mysql6.0\share\charsets\ |+--------------------------+-----------------------------+8 rows in set (0.00 sec)
We can see that character_set_client and character_set_results are both UTF-8 encoded, and now they are all modified to gbk
mysql> set character_set_client=gbk;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_results=gbk;Query OK, 0 rows affected (0.00 sec)
Use show variables like 'Char % '; to query
mysql> show variables like 'char%';+--------------------------+-----------------------------+| Variable_name | Value |+--------------------------+-----------------------------+| character_set_client | gbk || character_set_connection | gbk || character_set_database | gbk || character_set_filesystem | binary || character_set_results | gbk || character_set_server | gbk || character_set_system | utf8 || character_sets_dir | D:\mysql6.0\share\charsets\ |+--------------------------+-----------------------------+
View the content in the database.
Mysql> select * from test; + ------ + -------- + | id | name | + ------ + -------- + | 1 | Li Xiaofeng | 2 | Wang Xiaofeng | 3 | Zhang Xiaoxue | 4 | Wang Xuefeng | 5 | Lu Yun | 6 | peach blossom girl | 1 | demo1 | 2 | demo2 | 3 | demo3 | + ------ + -------- + 9 rows in set (0.00 sec)