mysql高版本数据库表名在低版本乱码 我用5.1.37建表,表名是中文导入5.0.24a,表名无法识别,但是内容中文可以识别有什么办法解决吗 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 外链给封了,请看http://img615.ph.126.net/QUexCA0t9-H5tE_ExvrPKw==/1926696215585603851.jpghttp://img615.ph.126.net/YLj97zy1D0H423MleyGhzA==/1926696215585603840.jpg 将你的旧版本的配置文件改下[mysql]default-character-set=utf8[mysqld]default-character-set=utf8或者更改如下变量 将latin改为utf8mysql> show variables like "%char%" -> ;+--------------------------+----------------------------+| Variable_name | Value |+--------------------------+----------------------------+| character_set_client | latin1 || character_set_connection | latin1 || character_set_database | latin1 || character_set_filesystem | binary || character_set_results | latin1 || character_set_server | latin1 || character_set_system | utf8 || character_sets_dir | /usr/share/mysql/charsets/ |+--------------------------+----------------------------+8 rows in set (0.00 sec) mysql> show variables like "%char%" -> ;+--------------------------+-------------------------------------------+| 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 | utf8 || character_sets_dir | D:\MySQL\MySQL Server 5.1\share\charsets\ |+--------------------------+-------------------------------------------+8 rows in set (0.00 sec)似乎并不是这个的问题,我新旧版本都设置的是gb2312 mysql如何设置ssl连接? mysql怎么启动啊 关于MySQL存储过程中嵌套循环的一个问题 mysql两列想减负数显示问题 如何设置可以使mysql储存越南文与中文? 想知道一个可用的集群安装表 求助:ado向MySQL的BLOB存图像文件怎么多存了一些字节? sql 判断时候提示从数据类型 varchar 转换为 numeric 时出错. 查询问题 求教mysql触发器生成流水号 mysql怎么知道哪个表被谁,或者IP锁着? 关于mysql存储过程使用 check table
http://img615.ph.126.net/QUexCA0t9-H5tE_ExvrPKw==/1926696215585603851.jpghttp://img615.ph.126.net/YLj97zy1D0H423MleyGhzA==/1926696215585603840.jpg
[mysql]default-character-set=utf8
[mysqld]
default-character-set=utf8
或者更改如下变量 将latin改为utf8
mysql> show variables like "%char%"
-> ;
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
-> ;
+--------------------------+-------------------------------------------+
| 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 | utf8 |
| character_sets_dir | D:\MySQL\MySQL Server 5.1\share\charsets\ |
+--------------------------+-------------------------------------------+
8 rows in set (0.00 sec)
似乎并不是这个的问题,我新旧版本都设置的是gb2312