oracle如何查看数据库的字符集?

发布时间:2019-03-16 21:42     分类:oracle

软件环境:
1、Windows NT4.0+ORACLE 8.0.4
2、ORACLE安装路径为:C:\ORANT

实现方法:
 SQL> conn sys/change_on_install
 SQL> desc props$
 SQL> set arraysize 1
 SQL> col value$ format a40   --格式化value$的输出为40个字符宽
 SQL> select name,value$ from props$ where name='NLS_CHARACTERSET';

 SQL> conn system/manager
 SQL> select * from nls_database_parameters;
 SQL> select * from V$NLS_PARAMETERS;

SQL> select * from nls_database_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-YY
NLS_DATE_LANGUAGE                        AMERICAN
NLS_CHARACTERSET                         ZHS16GBK
NLS_SORT                                 BINARY
NLS_NCHAR_CHARACTERSET                   ZHS16GBK
NLS_RDBMS_VERSION                        8.0.4.0.0

查询到12记录.

SQL> 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_NCHAR_CHARACTERSET                   ZHS16GBK

查询到11记录.

 

评论

推荐文章