LOAD DATA INFILE 'c:/db.txt'
INTO TABLE tableName
CHARACTER SET utf8
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
(filed1,filed2,filed3)
db结构如下:
CREATE TABLE `tableName` (
`filed1` int(11) NOT NULL auto_increment,
`filed2` varchar(10) NOT NULL default '' COMMENT '分值',
`filed3` varchar(100) default NULL,
PRIMARY KEY (`filed1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;报错如下:
incorrect string value ‘岁’ for column ‘filed3’at row 1导入数据文件如下:
1|99||19岁
2|92||19岁
3|93||19岁
show variables like 'character_set_%';
返回如下:
"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:\\info\\"
字符编码我看了都是utf8我觉得应该没问题啊。
然后我看网上说下面这句我也试试看了反正网上很多方法都试试看了都不行啊。有人知道为什么吗?
alter table tableName modify filed3 varchar(100) character set utf8;
INTO TABLE tableName
CHARACTER SET utf8
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
(filed1,filed2,filed3)
db结构如下:
CREATE TABLE `tableName` (
`filed1` int(11) NOT NULL auto_increment,
`filed2` varchar(10) NOT NULL default '' COMMENT '分值',
`filed3` varchar(100) default NULL,
PRIMARY KEY (`filed1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;报错如下:
incorrect string value ‘岁’ for column ‘filed3’at row 1导入数据文件如下:
1|99||19岁
2|92||19岁
3|93||19岁
show variables like 'character_set_%';
返回如下:
"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:\\info\\"
字符编码我看了都是utf8我觉得应该没问题啊。
然后我看网上说下面这句我也试试看了反正网上很多方法都试试看了都不行啊。有人知道为什么吗?
alter table tableName modify filed3 varchar(100) character set utf8;
解决方案 »
- 令人疑惑的MySql版本号,官网最新版不是5.5么?怎么有09年的7.0版
- 求一条简单的Ssql语句
- 刚接触 mysql ,在数据库中的查询问题,请高手指教
- 请教一个update语句, where中的值是跳跃的范围条件。怎么做啊?
- MySql导入数据,怎么会这样意外!!!
- 在存储过程的delete中使用传入的参数出错
- sql操作改变mysql数据库字段属性怎么做?
- 请问PostgreSQL在window上怎么安装
- PostgreSQL的Function返回Select的结果集如何做?谢谢!
- 在win2000下 mysql 可以安装两个吗?怎么装?
- 我在linux下装了个mysql服务器,然后想在window下用ODBC连过去,可是连接不了
- 那里能够快速下载到历史版本的mysql?
or
set names 'gb2312'DOS不支持UTF8