如何查到数据库字符集，谢谢AMERICAN_AMERICA.AL32UTF8

Question

AMERICAN_AMERICA.AL32UTF8  哪个地方查到的数据库字符集是这样显示的，谢谢

Answer 1

select * from nls_database_parameters;

Answer 2

看这个：
select sys_context('USERENV', 'LANGUAGE') from dual;

Answer 3

一楼给的能查到american 
america  
al32utf8  
这些都是不在同一行上，另UTF8和AL32UTF8有什么区别没

Answer 4

--查看当前数据库字符集设置
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_TIME_FORMAT                          HH.MI.SSXFF AMPARAMETER                                VALUE
---------------------------------------- ------------------------------------------------------------
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_NCHAR_CHARACTERSET                   AL16UTF16
NLS_RDBMS_VERSION                        11.1.0.6.020 rows selected.SQL>   

Answer 5

SQL> select sys_context('USERENV', 'LANGUAGE') from dual;SYS_CONTEXT('USERENV','LANGUAGE')
-------------------------------------------------------------------------------------------------------------------------
AMERICAN_AMERICA.AL32UTF8SQL> 
SQL> 
SQL> SELECT USERENV('LANGUAGE') "Language" FROM DUAL;Language
--------------------------------------------------------------------------------------------------------
AMERICAN_AMERICA.AL32UTF8

Answer 6

select * from nls_database_parameters;