查询 oracle字符集,查看oracle字符集

字符集

SQL> select *

from v$nls_parameters where parameter='NLS_CHARACTERSET';

PARAMETER                      VALUE

------------------------------

--------------------

NLS_CHARACTERSET               WE8ISO8859P1

SQL>

SQL> select

userenv('language') from dual;

USERENV('LANGUAGE')

----------------------------------------------------

AMERICAN_AMERICA.WE8ISO8859P1

SQL>

SQL> select * from v$nls_parameters where parameter like 'NLS_%';

PARAMETER                      VALUE

------------------------------ --------------------

NLS_LANGUAGE                   AMERICAN

NLS_TERRITORY                  AMERICA

NLS_CURRENCY                   $

NLS_ISO_CURRENCY               AMERICA

NLS_NUMERIC_CHARACTERS         .,

NLS_CALENDAR                   GREGORIAN

NLS_DATE_FORMAT                DD-MON-RR

NLS_DATE_LANGUAGE              AMERICAN

NLS_CHARACTERSET               WE8ISO8859P1

NLS_SORT                       BINARY

NLS_TIME_FORMAT                HH.MI.SSXFF AM

PARAMETER                      VALUE

------------------------------ --------------------

NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXF

F AM

NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR

NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXF

F AM TZR

NLS_DUAL_CURRENCY              $

NLS_NCHAR_CHARACTERSET         AL16UTF16

NLS_COMP                       BINARY

NLS_LENGTH_SEMANTICS           BYTE

PARAMETER                      VALUE

------------------------------ --------------------

NLS_NCHAR_CONV_EXCP            FALSE

19 rows selected.