Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sqlldr question with danish characters
Hi there.
I have a file with lines I want to load into a database. The lines have textstrings which contain danish characters. I can't seem to get it to work.
According to the manual, it is something with the NSL_LANG option in the control file to sqlldr, isn't is? But where to put it?
My control file looks like this;
LOAD DATA
INFILE 'RoadNames.dat'
REPLACE
INTO TABLE RoadNamesTemp
FIELDS TERMINATED BY ';'
(kom,
Road_Code,
Road_Name,
husfrom,
husto,
lu,
planzone,
Postal_Code,
Postal_District)
-- Eliasen Jr.Received on Wed Dec 19 2001 - 02:37:43 CST