Re: Export / Import - Unix

Sybrand Bakker wrote in message <35FD811D.67FF38E1_at_sybrandb.demon.nl>...
>Hi Maitee,
>
>Try setting the NLS_LANGUAGE environment variable to
>AMERICAN_AMERICA.WE8ISO8859P1.
>My experience on AIX tells it defaults to US7ASCII, regardless of the
>characterset of the database. This is probably why your diacritical
characters
>are translated.
>BTW: If you use a direct export on Unix, NLS_LANGUAGE is ignored, data is
always
>exported in the characterset of the database.
>

Just right. But if it is a shell env. variable, it is NLS_LANG, not NLS_LANGUAGE.
NLS_LANGUAGE determines only the language and does not include charset. And... it's used to set in init.ora.

Regards
Piotr Kolodziej
pkol_at_otago.gda.pl Received on Tue Sep 15 1998 - 01:22:13 CDT