我是使用CMD形式向MySQL数据库中插入的数据.
数据库的编码如下:
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.67, for Win32 (ia32)Connection id: 32
Current database: nitpro
Current user: System@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.0.67-community-nt MySQL Community Edition (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 2 hours 48 min 42 sec
查看表的编码也是UTF-8
mysql> show create table dept;
+-------+--------------------------------
| Table | Create Table+-------+--------------------------------
| dept | CREATE TABLE `dept` (
`deptno` char(2) NOT NULL,
`deptname` varchar(10) default NULL,
PRIMARY KEY (`deptno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+--------------------------------
1 row in set (0.00 sec)都设置成了UTF-8
然后我插入的语句中有汉字,它说:
ERROR 1366 (HY000): Incorrect string value: '\xC8\xCB\xCA\xC2\xB2\xBF' for column 'deptname' at row 1
数据库的编码如下:
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.67, for Win32 (ia32)Connection id: 32
Current database: nitpro
Current user: System@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.0.67-community-nt MySQL Community Edition (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 2 hours 48 min 42 sec
查看表的编码也是UTF-8
mysql> show create table dept;
+-------+--------------------------------
| Table | Create Table+-------+--------------------------------
| dept | CREATE TABLE `dept` (
`deptno` char(2) NOT NULL,
`deptname` varchar(10) default NULL,
PRIMARY KEY (`deptno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+--------------------------------
1 row in set (0.00 sec)都设置成了UTF-8
然后我插入的语句中有汉字,它说:
ERROR 1366 (HY000): Incorrect string value: '\xC8\xCB\xCA\xC2\xB2\xBF' for column 'deptname' at row 1
解决方案 »
- 再请教写一个SQL语句!!
- mysql中求交集的问题,在线等~~
- 【求助】mysql 分组后,如何在每个组中显示序号?
- mysqlslap 问个参数,结果。
- python连接MySQL问题
- 关于STMT求详解
- 不太懂mysql的查询,如果查“where name like 'a'”会把全中文姓名也查出来
- LOAD的奇怪问题
- 为什么我的的mysql不能用
- 急!请教各位高手:请问mysql中如何将varchar类型转换成integer类型?
- mysql绿色版6的使用
- 请高手指教:Can not issue data manipulation statement with executeQuery().我用的是MySQL4.1,mysql-connector-java-3.1.14,Tomcat5.0
看到尽快回复下我很急,谢谢