18 Sept 2013

Check DB is unicode or non-unicode

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.

No comments:

Post a Comment