在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
....
麻烦各位帮我看看……
解决方案 »
- Navicat for MySql 如何使用?
- update想用变量(mysql)
- ERROR 1172 (42000): Result consisted of more than one row?
- 请问,VB中如何向MYSQL数据库中插入图片呀..(BLOB数据类型),最好有代码,请高手看过来
- MySQL中存储中文用utf8还是gb2312? longtext是最长的字符类型吗,和varchar比呢?
- 大家誰有DELPHI開發POSTGRES的好書啊
- 请问MySQL的varchar,最大长度是多少?
- mysql 备份
- 问一条语句
- mysql数据库sum问题,求大神帮忙?????????
- 求个sql
- 如何将xml文件导入mysql
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'; 一下,