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

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

6 个解决方案

#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                                                     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

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_NCHAR_CHARACTERSET                                           AL16UTF16

NLS_COMP                                                         BINARY

NLS_LENGTH_SEMANTICS                                             BYTE

NLS_NCHAR_CONV_EXCP                                              FALSE

原文见http://www.inthirties.com/?p=516



==================================================================
Inthirties关注Oracle数据库 优化，安全，备份，恢复，迁移，故障处理

如果你需要帮助或想和我一起学习的请联系
联系方式QQ：370140387
QQ群:  85837884(注明：数据库)
电子邮件：[e-mail]
网站: http://www.inthirties.com

#2

用SYSDBA进去 选择

select * from nls_database_parameters

#3

select userenv('language') from dual

#4

前面的都对！

#5

select userenv('language') from dual

#6

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                                              FALSE

19 rows selected
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK