Sqlloader lssues
Hi,
I have loaded a csv using sqlloader. But some of the apostrophe' is not coming up properly. It is seen as a '?'.
Here is a part of my ctl file script;
OPTIONS (SKIP = 1)
load data
CHARACTERSET WE8MSWIN1252
infile '/tmp/occi/occi.csv'
insert into table GRAYS_WEBSITE_OCCI_TEMP
fields terminated by ","
optionally enclosed by '"'
trailing nullcols
(
LANGUAGE char(8),
ORACLE_ITEM_CODE char(40) ,
OCCITANE_CODE char(15) ,
PRODUCT_NAME char(1500),
PRODUCT_DESC char(1500) ,
STATUS char(25),
SKIN_TYPE char(100))
Here is a sample of my data. Note that I have given for field product_desc