Re: How detemining the character set?

From: Hakan Eren <sarisin_at_interlog.com>
Date: 1997/06/26
Message-ID: <33B31E9F.4388@interlog.com>#1/1

fgalot_at_x-lan.alienor.fr wrote:
>
> I'd like to know the character set used by my DataBase.
> I've got Oracle 7.1 on WNT.
>
> Thanks for help.
> --
> ---------------------------------------
> ®
> ®
> | ®
> O_O ®
> ®
> |
> O_O
> -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
> Fred Galot
> fgalot_at_x-lan.alienor.fr

Kindly try this

SQL> select * from nls_database_parameters;

PARAMETER                      VALUE
------------------------------ ------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_DATE_FORMAT                DD-MON-YY
NLS_DATE_LANGUAGE              AMERICAN
NLS_CHARACTERSET               WE8ISO8859P1
NLS_SORT                       BINARY
NLS_CALENDAR                   GREGORIAN
NLS_RDBMS_VERSION              7.3.3.0.0

11 rows selected.

Hakan Eren
InfoPower International Inc.
ERP/MRPII/DBMS Consulting and Software

Phone:905-507-2100
Fax:905-507-2108
E-mail:hakan_at_infopwr.com

prabir_at_infopwr.com Received on Thu Jun 26 1997 - 00:00:00 CDT