在SQLyog中查看数据库数据,中文显示是正常的,但一导出成sql文件,里面的中文就全变成?问号。
下面是我mysql目前的编码情况,请高手指点一下,我的配置哪里有问题?+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_server     | gb2312                   |
| character_set_system     | utf8                     |
| character_set_database   | gb2312                   |
| character_set_client     | gb2312                   |
| character_set_connection | gb2312                   |
| character-sets-dir       | D:\mysql\share\charsets/ |
| character_set_results    | gb2312                   |
+--------------------------+--------------------------+mysql> SHOW VARIABLES LIKE 'collation_%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | gb2312_chinese_ci |
| collation_database   | gb2312_chinese_ci |
| collation_server     | gb2312_chinese_ci |
+----------------------+-------------------+