设置Mysql字符集
mysql> show variables like ‘character\_set\_%’;
+————————–+——-+
| Variable_name??????????? | Value |
+————————–+——-+
| character_set_client???? | gbk?? |
| character_set_connection | gbk?? |
| character_set_database?? | gbk?? |
| character_set_results??? | gbk?? |
| character_set_server???? | gbk?? |
| character_set_system???? | utf8? |
+————————–+——-+
6 rows in set (0.00 sec)
mysql>
设置字符集
mysql> set character_set_server =gbk;
Query OK, 0 rows affected (0.00 sec)