From: Toomas Kiisk <vix@medisoft.ee>
Subject: Re: oraenv description
Date: 1997/09/09
Message-ID: <Pine.LNX.3.96.970909160519.9375A-100000@lx.medisoft.ee>#1/1
References: <5um7af$3se$3@peanuts.Materna.DE> <Pine.LNX.3.96.970905124219.22612A-100000@lx.medisoft.ee> <5v314m$ba$1@peanuts.Materna.DE>
X-Complaints-To: usenet@kadri.ut.ee
X-Trace: kadri.ut.ee 873811490 10967 (None) 194.126.97.34
Newsgroups: comp.databases.oracle.server



On 9 Sep 1997, Joachim Flierdl wrote:

<snip>

| If I call '. oraenv', the NLS_LANG variable is ignored
| (sqlplus shows data still with the 'GERMAN_GERMANY.EEC8EUROPA3'
| character set. Otherwise sqlplus shows data with the
| right 'GERMAN_GERMANY.WE8ISO8859P1' character set). May be
| oraenv isn't the problem, but isn't it a strange behaviour?
| 

Hi

This really _is_ a bit strange.. I recommend you keep NLS setup as
simple as possible, because these variables can override each other's
settings. `env | grep NLS` might give you idea. Correct $NLS_LANG is
often the only thing, that needs to be set.

vix