Re: what character set DB created with???

From: Kevin A Lewis <Kevin_A_Lewis_at_Hotmail.com>
Date: 2000/03/10
Message-ID: <Q24y4.10$nM.3053@newreader.ukcore.bt.net>#1/1

I always thought that the plainest way was to

    SVRMGR> select * from nls_database_parameters;

PARAMETER                      VALUE
------------------------------ ------------------------------
NLS_NCHAR_CHARACTERSET         US7ASCII
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               US7ASCII
NLS_SORT                       BINARY
NLS_CALENDAR                   GREGORIAN
NLS_RDBMS_VERSION              7.2.3.0.0

12 rows selected.

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United
Kingdom)
                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document
are not necessarily those of BOCM PAULS Ltd.
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
news:952671442.8579.0.pluto.d4ee154e_at_news.demon.nl...


> select * from sys.props$.

> This may not apply to all versions.

>

> Hth,

>

> Sybrand Bakker, Oracle DBA

>

> Jim Gregory <JG200024_at_NCR.com> wrote in message

> news:38c7e157$1_at_rpc1284.daytonoh.ncr.com...

> > How can I find out what character set a database was created with,

 without


> > having the original create scripts available to check?

> >

> > --

> > Jim Gregory

> >

> >

> >

> >

>

>

Received on Fri Mar 10 2000 - 00:00:00 CST