- 论坛徽章:
- 0
|
用load data infile导入数据。发现里面的汉字导入后都是空的,其它数据都是正常的。请问是什么原因呢?
insert into 的时候还没有问题。
文本数据为:
6020605,"matcdd","马天驰","4212106010134","021-88888888","男"," ",603,6040218,20060923,"XXX@XX.com.cn","42801",33,"0000",0,999
脚本为
load data local infile "c:\\t_em_employee4.del" into table t_em_employee FIELDS TERMINATED BY ',' ENCLOSED BY '"';
结果却是:
| 6020605 | matcdd | | 4212106010134 | 021-88888888 | | | 603 | 6040218 | 2006-09-23 | XXX@XX.com.cn | 42801 | | 0000 | 0 | 999 |
汉字没有了,那个33也没有了。
当我insert into t_em_employee
values(6020605,'matcdd','马天驰','4212106010134','021-88888888,'','男','',603,6040218,20060923,'[email=]XXX@XX.com.cn','42801','33','0000',0,999[/email]);
的时候还一切正常!!
咋回事呢? |
|