怎么查看数据库的字符集

这篇文章主要介绍“怎么查看数据库的字符集”，在日常操作中，相信很多人在怎么查看数据库的字符集问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”怎么查看数据库的字符集”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

通过数据字典查看

SYS@hyyk> 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              yyyy-mm-dd hh34:mi:ss

NLS_DATE_LANGUAGE            AMERICAN

NLS_CHARACTERSET             AL32UTF8

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

2.数据库字符集信息存在一个字典表props$中 我们可以从该表获得

----11.2版本

SYS@hyyk> select distinct dbms_rowid.rowid_relative_fno(rowid) file# from props$;

     FILE#

----------

     1

SYS@hyyk> select distinct dbms_rowid.rowid_block_number(rowid) blk# from props$;

      BLK#

----------

       801

[oracle@pc6 ~]$ dd if=/u01/app/oracle/oradata/hyyk/system01.dbf  of=hyyk  bs=8192 skip=801 count=1

[oracle@pc6 ~]$ strings hyyk

GLOBAL_DB_NAME

HYYK

Global database name,

DBTIMEZONE

00:00

DB time zone,

NO_USERID_VERIFIER_SALT 8BF56230FC49D6ECFE53EB96A5922DD5,

WORKLOAD_REPLAY_MODE

bPREPARE implies external replay clients can connect; REPLAY implies workload replay is in progress,

WORKLOAD_CAPTURE_MODE

/CAPTURE implies workload capture is in progress,

EXPORT_VIEWS_VERSION

Export views revision #,

DEFAULT_PERMANENT_TABLESPACE

USERS$Name of default permanent tablespace,

GLOBAL_DB_NAME

SEEDDATA

Global database name,

NLS_RDBMS_VERSION

11.2.0.1.0 RDBMS version for NLS parameters,

NLS_NCHAR_CHARACTERSET    AL16UTF16

NCHAR Character set,

NLS_NCHAR_CONV_EXCP

FALSE

NLS conversion exception,

NLS_LENGTH_SEMANTICS

BYTE

NLS length semantics,

NLS_COMP

BINARY

NLS comparison,

NLS_DUAL_CURRENCY

Dual currency symbol,

NLS_TIMESTAMP_TZ_FORMAT

DD-MON-RR HH.MI.SSXFF AM TZR

Timestamp with timezone format,

NLS_TIME_TZ_FORMAT

HH.MI.SSXFF AM TZR

Time with timezone format,

NLS_TIMESTAMP_FORMAT

DD-MON-RR HH.MI.SSXFF AM

Time stamp format,

NLS_TIME_FORMAT

HH.MI.SSXFF AM

Time format,

NLS_SORT

BINARY

Linguistic definition,

NLS_DATE_LANGUAGE

AMERICAN

Date language,

NLS_DATE_FORMAT    DD-MON-RR

Date format,

NLS_CALENDAR    GREGORIAN

Calendar system,

NLS_CHARACTERSET

AL32UTF8

Character set,

NLS_NUMERIC_CHARACTERS

Numeric characters,

NLS_ISO_CURRENCY

AMERICA

ISO currency,

NLS_CURRENCY

Local currency,

NLS_TERRITORY

AMERICA    Territory,

NLS_LANGUAGE

AMERICAN

Language,

DEFAULT_TBS_TYPE    SMALLFILE

Default tablespace type,

DST_SECONDARY_TT_VERSION

0'Version of secondary timezone data file,

DST_PRIMARY_TT_VERSION

11%Version of primary timezone data file,

DST_UPGRADE_STATE

NONE&State of Day Light Saving Time Upgrade<

DBTIMEZONE

-07:00

DB time zone,

TDE_MASTER_KEY_ID,

Flashback Timestamp TimeZone

GMT"Flashback timestamp created in GMT,

DEFAULT_TEMP_TABLESPACE

TEMP$Name of default temporary tablespace,

DEFAULT_EDITION

ORA$BASE$Name of the database default edition,

DEFAULT_PERMANENT_TABLESPACE

SYSTEM$Name of default permanent tablespace,

DEFAULT_TEMP_TABLESPACE

SYSTEM$Name of default temporary tablespace,

    DICT.BASE

2 dictionary base tables version #

到此，关于“怎么查看数据库的字符集”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！