Re: retrieve nls_lang out of db ?

From: Thomas Schwickert <thomas.schwickert_at_itellium.com>
Date: Thu, 25 Jan 2001 09:50:25 GMT
Message-ID: <94ost0$sb$1@nnrp1.deja.com>

In article <94op2n$e9r$1_at_s1.read.news.oleane.net>,   "Michel Cadot" <micadot_at_netcourrier.com> wrote:
> You can find your current settings of nls parameters in
 v$nls_parameters.
>
> --
> Have a nice day
> Michel
>

Hi Michael,

thanks for your reply, but I think, you are wrong. With v$nls_parameters, you get NLS_CHARACTERSET, which is the characterset of the database, not the one, your client is using in fact
(just set NLS_LANG=america_american.us7ascii, use sqlplus  and query v$nls_parameters, it will show you the characterset of the database)

Anyway, thanks
 Thomas

Thomas Schwickert                              Phone: +49 69 - 404 8093
Itellium System & Services GmbH     Fax:      +49 69 - 404 5561

60386 Frankfurt
Germany

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 25 2001 - 03:50:25 CST