用本机用navicat连接局域网内一台mysql服务器,,,显示字符集设置,,结果集中包含中文全显示为?????????
show variables like "%char%";
+--------------------------+--------------------------------------+
| Variable_name            | Value                                |
+--------------------------+--------------------------------------+
| character_set_client     | latin1                               |
| character_set_connection | latin1                               |
| character_set_database   | utf8                                 |
| character_set_filesystem | binary                               |
| character_set_results    | latin1                               |
| character_set_server     | utf8                                 |
| character_set_system     | utf8                                 |
| character_sets_dir       | C:\Server_Core\MySQL\share\charsets\ |
+--------------------------+--------------------------------------+在这台mysql服务器上,,显示字符集设置
show variables like "%char%";
+--------------------------+--------------------------------------+
| Variable_name            | Value                                |
+--------------------------+--------------------------------------+
| character_set_client     | utf8                                 |
| character_set_connection | utf8                                 |
| character_set_database   | utf8                                 |
| character_set_filesystem | binary                               |
| character_set_results    | utf8                                 |
| character_set_server     | utf8                                 |
| character_set_system     | utf8                                 |
| character_sets_dir       | C:\Server_Core\MySQL\share\charsets\ |
+--------------------------+--------------------------------------+my.ini[client]
port=3306
character_set_client=utf8
character_set_connection=utf8
character_set_results=utf8怎么设置一下,用navicat查询结果包含中文不乱码

解决方案 »

  1.   

    在navicat上执行上面的命令后再进行查询看看
      

  2.   

    请问在my.ini怎么设置一下??
      

  3.   

    在本机上
    set names 'UTF8'
    在新字符集下重新插入记录
      

  4.   

    set names 'UTF8' 这样做,显示中文正常在my.ini里可不可以设置一下
      

  5.   

    客户端的配置文件 编码格式配置下-------------------------+--------------------------------------+ 
    | Variable_name            | Value                                | 
    +--------------------------+--------------------------------------+ 
    | character_set_client    | latin1                              | 
    | character_set_connection | latin1                              | 
    | character_set_database  | utf8                                | 
    | character_set_filesystem | binary                              | 
    | character_set_results    | latin1                              | 
    | character_set_server    | utf8                                | 
    | character_set_system    | utf8                                | 
    | character_sets_dir      | C:\Server_Core\MySQL\share\charsets\ | 
    看起来你的编码格式不统一
      

  6.   

    [mysqld]
    default-character-set=utf8
      

  7.   

    那个我是菜鸟 我也遇到乱码的问题 mysqlid指的什么 我填的数据库名称 运行报错 不知为什么