Re: Server character set

#1

Hi!

I'd rather use:

select value from nls_database_parameters where parameter =
'NLS_CHARACTERSET';

Tanel.

"Abhijith" <abhijith (AT) nomail (DOT) com> wrote

Quote:

try
SELECT nls_charset_name(nls_charset_id('CHAR_CS')) FROM dual

Abhijith.

Holger Heidenbluth wrote:
Hi all,

can anybody tell me how I can retrieve the character set
name that once has been used to create the database?

Thanks
Holger

#2

Or even simpler: select * from database_properties;

;-*

"Tanel Poder" <tanel@@peldik.com> wrote

Quote:

Hi!

I'd rather use:

select value from nls_database_parameters where parameter =
'NLS_CHARACTERSET';

Tanel.

"Abhijith" <abhijith (AT) nomail (DOT) com> wrote in message
news:3EF6E95D.2060009 (AT) nomail (DOT) com...
try
SELECT nls_charset_name(nls_charset_id('CHAR_CS')) FROM dual

Abhijith.

Holger Heidenbluth wrote:
Hi all,

can anybody tell me how I can retrieve the character set
name that once has been used to create the database?

Thanks
Holger

#3

Incidentally:

SQL> select * from database_properties;

PROPERTY_NAME
------------------------------
PROPERTY_VALUE
----------------------------------------------------------------------------
----
DESCRIPTION
----------------------------------------------------------------------------
----
DICT.BASE
2
dictionary base tables version #

DEFAULT_TEMP_TABLESPACE
TEMP
Name of default temporary tablespace

DBTIMEZONE
-07:00
DB time zone

NLS_LANGUAGE
AMERICAN
Language

NLS_TERRITORY
AMERICA
Territory

NLS_CURRENCY
$
Local currency

NLS_ISO_CURRENCY
AMERICA
ISO currency

NLS_NUMERIC_CHARACTERS
..,
Numeric characters

NLS_CHARACTERSET
AL32UTF8
Character set

NLS_CALENDAR
GREGORIAN
Calendar system

NLS_DATE_FORMAT
DD-MON-RR
Date format

NLS_DATE_LANGUAGE
AMERICAN
Date language

NLS_SORT
BINARY
Linguistic definition

NLS_TIME_FORMAT
HH.MI.SSXFF AM
Time format

NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
Time stamp format

NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
Time with timezone format

NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
Timestamp with timezone format

NLS_DUAL_CURRENCY
$
Dual currency symbol

NLS_COMP
BINARY
NLS comparison

NLS_LENGTH_SEMANTICS
BYTE
NLS length semantics

NLS_NCHAR_CONV_EXCP
FALSE
NLS conversion exception

NLS_NCHAR_CHARACTERSET
AL16UTF16
NCHAR Character set

NLS_RDBMS_VERSION
9.2.0.1.0
RDBMS version for NLS parameters

GLOBAL_DB_NAME
GEN92.PICTON.COM
Global database name

EXPORT_VIEWS_VERSION
8
Export views revision #

25 rows selected.

Just so you know...

;-)

"Arcangelo" <arcangelo-c (AT) yahoo (DOT) com> wrote

Quote:

That would be because it is a new view in 9i.

You didn't specify your version.

So I had to guess.

;-)

"Avi Abrami" <aabrami (AT) intersystemsww (DOT) com> wrote in message
news:3EF91892.5010201 (AT) intersystemsww (DOT) com...
Arcangelo wrote:
Or even simpler: select * from database_properties;

Arcangelo,
It doesn't work for me :-(

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jun 25 06:30:21 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SQL> select * from database_properties;
select * from database_properties
*
ERROR at line 1:
ORA-00942: table or view does not exist

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Server character set

comp.databases.oracle.server comp.databases.oracle.server

Re: Server character set - 06-23-2003 , 06:33 PM

Re: Server character set - 06-24-2003 , 08:56 AM

Re: Server character set - 06-25-2003 , 08:18 AM