oracle 查看数据库字符集命令是什么啊？

Question

oracle 查看数据库字符集命令是什么啊？比方说，我想看下是gbd还是utf-8，然后调整jsp页面的语言设置，统一起来

Answer 1

呵呵呵刚看到一个简单的SQL> select userenv(’language’) from dual;USERENV(’LANGUAGE’)—————————————————-AMERICAN_AMERICA.WE8ISO8859P1
以前都是查数据字典的如下
SQL> select * from v$nls_parameters;SQL> select * from v$nls_parameters;PARAMETER                                                        VALUE—————————————————————- —————————————————————-NLS_LANGUAGE                                                     AMERICANNLS_TERRITORY                                                    AMERICANLS_CURRENCY                                                     $NLS_ISO_CURRENCY                                                 AMERICANLS_NUMERIC_CHARACTERS                                           .,NLS_CALENDAR                                                     GREGORIANNLS_DATE_FORMAT                                                  DD-MON-RRNLS_DATE_LANGUAGE                                                AMERICANNLS_CHARACTERSET                                                 WE8ISO8859P1NLS_SORT                                                         BINARYNLS_TIME_FORMAT                                                  HH.MI.SSXFF AMNLS_TIMESTAMP_FORMAT                                             DD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT                                               HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT                                          DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY                                                $NLS_NCHAR_CHARACTERSET                                           AL16UTF16NLS_COMP                                                         BINARYNLS_LENGTH_SEMANTICS                                             BYTENLS_NCHAR_CONV_EXCP                                              FALSE原文见http://www.inthirties.com/?p=516==================================================================
Inthirties关注Oracle数据库 优化，安全，备份，恢复，迁移，故障处理如果你需要帮助或想和我一起学习的请联系
联系方式QQ：370140387
QQ群:  85837884(注明：数据库)
电子邮件：[email protected]
网站: http://www.inthirties.com

Answer 2

用SYSDBA进去 选择select * from nls_database_parameters

Answer 3

select userenv('language') from dual

Answer 4

select userenv('language') from dual

Answer 5

QL> select * from v$nls_parameters;
PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_LANGUAGE                                                     SIMPLIFIED CHINESE
NLS_TERRITORY                                                    CHINA
NLS_CURRENCY                                                     RMB
NLS_ISO_CURRENCY                                                 CHINA
NLS_NUMERIC_CHARACTERS                                           .,
NLS_CALENDAR                                                     GREGORIAN
NLS_DATE_FORMAT                                                  DD-MON-YY
NLS_DATE_LANGUAGE                                                SIMPLIFIED CHINESE
NLS_CHARACTERSET                                                 ZHS16GBK
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                                                RMB
NLS_NCHAR_CHARACTERSET                                           AL16UTF16
NLS_COMP                                                         BINARY
NLS_LENGTH_SEMANTICS                                             BYTE
NLS_NCHAR_CONV_EXCP                                              FALSE19 rows selected
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK