Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Loading foreign characters in SQL LOADER
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.
-- Galen BoyerReceived on Mon Nov 25 2002 - 10:08:25 CST