Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to tell what value of NLS_LANG was used?
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