我用5.1.37建表,表名是中文导入5.0.24a,表名无法识别,但是内容中文可以识别有什么办法解决吗
解决方案 »
- MySql 的统计查询性能问题
- mysql安装的头痛问题
- 有个关于query browser 客户端软件的问题
- mysqlcc图形界面中建表时,无法处理中文
- mysql中的blob字段为什么写不进去,再没人回答我就要下岗了,神啊,救救我吧
- 字符两两一组反转
- 哪位仁兄,帮忙介绍一下mysql中,host表和columns_priv表的作用?
- mysql 联表查询的问题,请大家帮忙,谢谢
- mysqldump导入错误 ERROR 2002 (HY000): Can't connect to local MySQL server
- SQL语句中FREETEXTTABLE在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