Re: sqlldr question with danish characters

From: Andreas Stephan <as.no.spam.stedat_at_gmx.net>
Date: Wed, 19 Dec 2001 10:34:11 GMT
Message-ID: <3c206c09.85486673@by-news.bayer-ag.com>

On Wed, 19 Dec 2001 09:37:43 +0100, Jan Eliasen <eliasen_at_cs.auc.dk> wrote:

>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.
>

Hi,

try setting the NLS_LANG on the command prompt before running loader e.g. NLS_LANG=american_america.WE8ISO8859P1; export NLS_LANG or any character set that is appropriate for you.

Sure, the database has to support charactersets with at least 8bit. So if your db is built with american_america.us7ascii you will most likely have a problem.

hth
Andy

---

Andreas Stephan
Oracle DBA

---

Pls. remove .no.spam from my mailaddress Received on Wed Dec 19 2001 - 04:34:11 CST