我用5.1.37建表,表名是中文导入5.0.24a,表名无法识别,但是内容中文可以识别有什么办法解决吗

解决方案 »

  1.   

    外链给封了,请看
    http://img615.ph.126.net/QUexCA0t9-H5tE_ExvrPKw==/1926696215585603851.jpghttp://img615.ph.126.net/YLj97zy1D0H423MleyGhzA==/1926696215585603840.jpg
      

  2.   

    将你的旧版本的配置文件改下
    [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)
      

  3.   

    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