查看字符集设置
show variables like 'character_set_%';
+---------------------------+-------------------------+
| Variable_name | Value |
+---------------------------+-------------------------+
| collation_connection | gb2312_chinese_ci |
| collation_database | gb2312_chinese_ci |
| collation_server | gb2312_chinese_ci |
+---------------------------+-------------------------+
show variables like 'character_set_%';
+------------------------------------+----------------------------------------+
| Variable_name | Value |
+-----------------------------------+-----------------------------------------+
| character_set_client | gb2312 |
| character_set_connection | gb2312 |
| character_set_database | gb2312 |
| character_set_filesystem | binary |
| character_set_results | gb2312 |
| character_set_server | gb2312 |
| character_set_system | gb2312 |
| character_sets_dir | D:/wamp/mysql/share/charsets/ |
+------------------------------------+----------------------------------------+
(这个是我已经设置好的,比如把gb2312变为gbk则)
开始设置字符集
mysql> set character_set_client=gbk;
mysql> set character_set_connection=gbk;
mysql> set character_set_database=gbk;
mysql> set character_set_server=gbk;
OK!