Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to tell what value of NLS_LANG was used?

Re: how to tell what value of NLS_LANG was used?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 21 Oct 2000 11:04:20 +0200
Message-ID: <9tm2vsk9b5perdv6nk6dvnnhu34o5h20pf@4ax.com>

On Sat, 21 Oct 2000 06:46:43 GMT, eskimo1234_at_my-deja.com wrote:

>Is there a query to perform which will tell me what
>NLS_LANG setting was used for an Oracle8i 8.1.5 install?
>(HP-UX 11.x).
>
>It should've been set to AMERICAN_AMERICA.UTF8
>but we need to verify this.
>
>Thanks.
>
>Eskimo
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

You must be referring to the characterset used in the database creation, because NLS_LANG is not being observed, unless you don't specify a characterset.
You should refer to NLS_DATABASE_PARAMETERS or sys.props$

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Oct 21 2000 - 04:04:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US