我在mysql 中建了个表,用下面的insert 插入数据时会也错,请指教:
建表如下:
create table teacher(
id int(5) auto_increment not null primary key,
name char(128) not null
);
有错的插入方法如下:
insert into teacher values(Null,encode('il','df'));
insert into teacher values(NULL,encode('i','df'));错误:incorrect string value: '\xc0' for column 'name' at row 1如果这样插入就不会有错:
insert into teacher values(NULL,encode('somevalue','somepass'));为什么呢?
请指教,thanks
建表如下:
create table teacher(
id int(5) auto_increment not null primary key,
name char(128) not null
);
有错的插入方法如下:
insert into teacher values(Null,encode('il','df'));
insert into teacher values(NULL,encode('i','df'));错误:incorrect string value: '\xc0' for column 'name' at row 1如果这样插入就不会有错:
insert into teacher values(NULL,encode('somevalue','somepass'));为什么呢?
请指教,thanks
解决方案 »
- mysqldumpslow 分析慢查询日志
- DB集群谁弄过,有偿服务
- 关联查询的时候整型和字符型转换遇到的问题,请教高手。谢谢。
- 怎样删除游标当前所指行?
- 数据库里的数据突然全部不见了,怎么恢复呀??(要多少都给)
- 太急!网站论坛坏了,不知道该怎么操作了。请大家帮忙看看!谢谢
- 一个简单的问题。。。
- 从mysql、oracle、sqlserver、db2里取数据,怎样取最快?
- mysql中设置varchar(20000)之后,为什么还是不能添加那么多数据?
- mysql三表关联,根据主表返回的值,确定选择那个表查询
- Administrator 和 Query Browser
- MySQL Cluster如何使用InnoDB数据引擎?
+----------------------------+
| charset(encode('il','df')) |
+----------------------------+
| binary |
+----------------------------+
1 row in set (0.00 sec)mysql>
mysql> create table teacher(
-> id int(5) auto_increment not null primary key,
-> name char(128) not null
-> ) DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.09 sec)mysql> insert into teacher values(Null,encode('il','df'));
ERROR 1366 (HY000): Incorrect string value: '\xC0"' for column 'name' at row 1mysql> alter table teacher MODIFY `name` char(128) CHARACTER SET binary;
Query OK, 0 rows affected (0.14 sec)
Records: 0 Duplicates: 0 Warnings: 0mysql>
mysql> insert into teacher values(Null, encode('il','df'));
Query OK, 1 row affected (0.06 sec)mysql>