在mysql可视化环境nvicat中插入了一些数据,然后再mysql的dos窗口客户端查询,中文都显示乱码了!
我的D:\Program Files\MySQL\MySQL Server 5.0下的my.ini文件:
[client]port=3306[mysql]default-character-set=utf8#.......
[mysqld]port=3306default-character-set=utf8*************************
mysql> show variables;
....
 bulk_insert_buffer_size                 | 8388608
 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                      | D:\Program Files\MyS
 collation_connection                    | utf8_general_ci
 collation_database                      | utf8_general_ci
 collation_server                        | utf8_general_ci
 completion_type                         | 0
 concurrent_insert                       | 1
....
麻烦各位帮我看看……

解决方案 »

  1.   

    http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
    MySQL 中文显示乱码
      

  2.   

    mysql的dos窗口客户端查询,中文都显示乱码了! 这是因为dos窗口用的gbk来解码显示的
      

  3.   

    我是楼主
    mysql> show create table tb_orderDetail;
    +----------------+------------------------------------------------------------------
    ------------------------------------------------------------------------------------
    -------------------------------------------------------------------------------+
    | Table          | Create Table                                                                               |
    +----------------+------------------------------------------------------------------
    ------------------------------------------------------------------------------------
    -------------------------------------------------------------------------------+
    | tb_orderDetail | CREATE TABLE `tb_orderdetail` (
      `ID` int(11) NOT NULL auto_increment,
      `orderID` int(11) NOT NULL,
      `ISBN` varchar(20) NOT NULL,
      `unitPrice` float NOT NULL,
      `count` int(11) NOT NULL,
      `bookshop` char(10) NOT NULL default 'BlueDot',
      PRIMARY KEY  (`ID`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
    +----------------+------------------------------------------------------------------
    ------------------------------------------------------------------------------------
    -------------------------------------------------------------------------------+
    1 row in set (0.05 sec)mysql> show full columns from tb_orderDetail;
    +-----------+-------------+-----------------+------+-----+---------+----------------
    --------+
    | Field     | Type        | Collation       | Null | Key | Default | Extra
    Comment |
    +-----------+-------------+-----------------+------+-----+---------+----------------
    --------+
    | ID        | int(11)     | NULL            | NO   | PRI | NULL    | auto_increment
            |
    | orderID   | int(11)     | NULL            | NO   |     | NULL    |
            |
    | ISBN      | varchar(20) | utf8_general_ci | NO   |     | NULL    |
            |
    | unitPrice | float       | NULL            | NO   |     | NULL    |
            |
    | count     | int(11)     | NULL            | NO   |     | NULL    |
            |
    | bookshop  | char(10)    | utf8_general_ci | NO   |     | BlueDot |
            |
    +-----------+-------------+-----------------+------+-----+---------+----------------
    --------+
    6 rows in set (0.00 sec)
    database,server,connection,table,columns,都是utf8,为什么在mysql的dos客户端查询还是显示奇怪的繁体字呢?O_O……
      

  4.   

    我是楼主
    还有在mysql的dos窗口客户端下,insert时,插入一些中文,则报以下错误,不知原因是否相同?
    ERROR 1366 (HY000): Incorrect string value: '\xBC\xC6\xCB\xE3\xBB\xFA...' for……
      

  5.   


    WINDOWS中的命令行工具(也就是你所说的DOS)是无法正常显示MYSQL中的UTF8的。所以你需要先 set name 'gb2312'; 一下,