Monday 13 February 2017

How to find the character set of oracle database?

SQL> select * from NLS_DATABASE_PARAMETERS;

PARAMETER                                     VALUE
------------------------------                   ---------------
NLS_LANGUAGE                        AMERICAN
NLS_TERRITORY                        AMERICA
NLS_CURRENCY                             $
NLS_ISO_CURRENCY                AMERICA
NLS_NUMERIC_CHARACTERS           .,
NLS_CHARACTERSET               AL32UTF8
NLS_CALENDAR                        GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                                        BINARY
NLS_NCHAR_CHARACTERSET         UTF8

PARAMETER                                     VALUE
------------------------------                   ---------------
NLS_SAVED_NCHAR_CS             WE8ISO8859P1
NLS_TIME_FORMAT                    HH.MI.SSXFF AM

                                 (OR)

SQL> select * from NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';

PARAMETER                                VALUE
------------------------------           ---------------
NLS_CHARACTERSET               AL32UTF8

The database character set in oracle determines the set of characters can be stored in the database. It is also used to determine the character set to be used for object identifiers and PL/SQL variables and for storing PL/SQL program source.


No comments:

Post a Comment