load data infile方式数据无法正确导入的问题导入数据中有0开头数据不对

[Benson2012]

Load data
Infile '/var/test/tmp/DALLUSERRTMP.cvs'
replace delete Into table KDCS_BROADBANDUSER
(ID "KDCS_BROADBANDUSER_SEQ.NEXTVAL",
ACCOUNT terminated by ',',
BANDWIDTH terminated by ',',
PROVINCE terminated by ',',
CITY terminated by ',',
CONNECTTYPE terminated by ',',
ACCOUNTTYPE terminated by ',')

数据格式：
02700428056,4M,71,0027,3,0
02700428788,4M,71,0027,3,0
02700428791,4M,71,0027,3,0
02700428793,4M,71,0027,3,0
02700428087,10M,71,0027,3,0
02700428790,10M,71,0027,3,0
02700400115,4M,71,0027,3,0
导入进去02700428056就成了2700428056了，请问是咋个解决这个问题呢？

[luoyoumou]

这个字段是数值类型吧？把这个字段修改成字符类型不就得了？

[Benson2012]

数据库字段是varchar2(30)类型，不是数值类型啊

[Benson2012]

我试过在0前加一个\后0数据就对了，但是要不修改文件才行。