在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
....
麻烦各位帮我看看……
我的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
....
麻烦各位帮我看看……
MySQL 中文显示乱码
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……
还有在mysql的dos窗口客户端下,insert时,插入一些中文,则报以下错误,不知原因是否相同?
ERROR 1366 (HY000): Incorrect string value: '\xBC\xC6\xCB\xE3\xBB\xFA...' for……
WINDOWS中的命令行工具(也就是你所说的DOS)是无法正常显示MYSQL中的UTF8的。所以你需要先 set name 'gb2312'; 一下,