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 Boyer
Received on Mon Nov 25 2002 - 10:08:25 CST
