在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 |
+----------------------+-------------------+
下面是我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 |
+----------------------+-------------------+
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货