Kbase 17077: How can I find out which codepage is set in ORACLE?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/9/2008 |
|
Status: Verified
GOAL:
How can I find out which codepage is set in ORACLE?
GOAL:
How to find out what character set ORACLE is using.
GOAL:
How to find out which codepage is being used by ORACLE.
FACT(s) (Environment):
Oracle Dataserver
FIX:
1. Use ORACLE SQL*Plus, SQL*Dba or Server Manager
2. Connect to ORACLE as Internal, SYS or SYSTEM
3. Issue the following SQL query:
SELECT VALUE FROM NLS_DATABASE_PARAMETERS
WHERE PARAMETER = 'NLS_CHARACTERSET';
Alternatively, following SQL statement displays all the NLS related settings for the database
SELECT * FROM NLS_DATABASE_PARAMETERS;
shows
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET US7ASCII
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_NCHAR_CHARACTERSET US7ASCII
NLS_RDBMS_VERSION 8.1.7.0.0