To check the database supports unicode or non unicode
-----------------------------------------------------------
SQL> SELECT TNAME FROM TAB;
SQL> SELECT TNAME FROM TAB WHERE TNAME LIKE '%NLS%'
SQL> DESC NLS_DATABASE_PARAMETERS;
Name Null? Type
--------------- -------- ----------------------------
PARAMETER NOT NULL VARCHAR2(30)
VALUE VARCHAR2(160)
SQL> SELECT PARAMETER,VALUE FROM NLS_DATABASE_PARAMETERS;
SQL> SET LINES 300 PAGES 300
SQL> /
PARAMETER VALUE
------------------------------------- --------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_NCHAR_CHARACTERSET UTF8
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8 ------------------------This AL32UTF8 SEARCH IN GOOGLE AND IT SHOWS THAT IT SUPPORTS ASIAN LANGUAGES
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_RDBMS_VERSION 11.2.0.2.0
20 rows selected.
-----------------------------------------------------------
SQL> SELECT TNAME FROM TAB;
SQL> SELECT TNAME FROM TAB WHERE TNAME LIKE '%NLS%'
SQL> DESC NLS_DATABASE_PARAMETERS;
Name Null? Type
--------------- -------- ----------------------------
PARAMETER NOT NULL VARCHAR2(30)
VALUE VARCHAR2(160)
SQL> SELECT PARAMETER,VALUE FROM NLS_DATABASE_PARAMETERS;
SQL> SET LINES 300 PAGES 300
SQL> /
PARAMETER VALUE
------------------------------------- --------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_NCHAR_CHARACTERSET UTF8
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8 ------------------------This AL32UTF8 SEARCH IN GOOGLE AND IT SHOWS THAT IT SUPPORTS ASIAN LANGUAGES
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_RDBMS_VERSION 11.2.0.2.0
20 rows selected.
No comments:
Post a Comment