Re: oracle strange beaviour

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Tue, 18 Dec 2001 17:19:00 +0100
Message-ID: <12ru1ukfn4vjkgll3m9l1rkaoqri3ddvhh@4ax.com>

On Tue, 18 Dec 2001 16:09:10 +0000 (UTC), "Mario Caputo" <buatt_at_caltanet.it> wrote:

>hi to all,
>
>I have installed a 9.0.1 oracle on SuSE Linux 7.2. I set all environment
>variables on /etc/profile.d/oracle.sh (that is called by /etc/rc.d/oracle).
>If a do "set" command i can see NLS_LANG variable correctly set to "italian"
>
>...
>NLS_CHARACTERSET=WE8ISO8859P1
>NLS_LANG=italian
>...
>
>All seems ok BUT... if I execute imp or exp utility I see messages in english
>(and they uses ASCII char encoding).
>Now is the strange: if I do
>
>export NLS_LANG=italian
>
>the NLS_LANG value has THE SAME VALUE THAN BEFORE but now imp and exp work
>correctly in italian!! HOW ?
>Probably I've not been clear in mind how environment variables works.. :(

NLS_LANG is made up of <country>_<territory>.<characterset> You are confusing NLS_LANG and NLS_LANGUAGE

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Dec 18 2001 - 10:19:00 CST