|
最近帮客户导数据比较多，用阿里云感觉不方便，Navicat Premium还是好用，但是数据稻城excel就会乱码！
解决方案：
1.看图说话，右键选中
2.三条SQL完成：
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| pay |
| performance_schema |
+--------------------+
17 rows in set (0.04 sec)
mysql> show variables like 'char%';
+------------------------+---------+
| Variable_name | Value |
+------------------------+---------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | |
+------------------------+---------+
8 rows in set (0.05 sec)
mysql> set names 'gbk'
-> ;
Query OK, 0 rows affected (0.01 sec)
mysql> show variables like 'char%';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | |
+------------------------+-------+
8 rows in set (0.07 sec)
3.试试，完成。 | 
转播
