Re: Loading foreign characters in SQL LOADER

From: Rick <al109rs_at_yahoo.com>
Date: 26 Nov 2002 08:22:14 -0800
Message-ID: <75ab9b03.0211260822.dfd0e70@posting.google.com>

Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<u7kf13a8t.fsf_at_standardandpoors.com>...
> On 25 Nov 2002, al109rs_at_yahoo.com wrote:
> > I am trying to load some comma delimited data in SQL LOADER but
> > some foreign characters get changed. E.g. TROMSØ becomes
> > TROMSX, BRATTVÅG becomes BRATTVEG. I have loaded similar data
> > using different methods (other than SQL LOADER) without
> > encountering this affect.
> >
>
> You probably have a different client setting for you NLS_LANG
> variable than the character set of Oracle. A conversion of the
> data happens on the way into Oracle which is munging your
> characters.

You are right. I had been assuming that NLS_LANG was set but because it was running in batch it didn't get the full environment set-up. I added
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1 and it was OK.

Cheers. Received on Tue Nov 26 2002 - 10:22:14 CST