oracle資料庫字符集資訊

select parameter,value 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 AM

PARAMETER                                         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                     10.2.0.1.0

20 rows selected.
NLS_CHARACTERSET是資料庫字符集，NLS_NCHAR_CHARACTERSET是國家字符集

ORACLE中有兩大類字元型資料，VARCHAR2是按照資料庫字符集來儲存資料。而NVARCHAR2是按照國家字符集儲存資料的。同樣，CHAR和NCHAR也一樣，一是資料庫字元符，一是國家字符集。
字符集不同，二進位制碼的組合就不同。
比如有一串二進位制資訊：1101,0110,1101,0000,1011,1001,1111,1010，按照16位雙位元組GBK字符集理解，可以代表“中國”兩個字。如果單位元組的字符集，這一串二進位制代表ASC碼為214、208、185、250的四個怪字元。
這就是字符集的作用，就是以什麼樣的形式理解資訊。

 

select NAME,VALUE$,COMMENT$ from props$;

NAME                           VALUE$                                   COMMENT$
------------------------------ ---------------------------------------- --------------------------------------------
DICT.BASE                      2                                        dictionary base tables version #
DEFAULT_TEMP_TABLESPACE        TEMP                                     Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE   USERS                                    Name of default permanent tablespace
DEFAULT_TBS_TYPE               SMALLFILE                                Default tablespace type
NLS_LANGUAGE                   AMERICAN                                 Language
NLS_TERRITORY                  AMERICA                                  Territory
NLS_CURRENCY                   $                                        Local currency
NLS_ISO_CURRENCY               AMERICA                                  ISO currency
NLS_NUMERIC_CHARACTERS         .,                                       Numeric characters
NLS_CHARACTERSET               AL32UTF8                                 Character set
NLS_CALENDAR                   GREGORIAN                                Calendar system

NAME                           VALUE$                                   COMMENT$
------------------------------ ---------------------------------------- --------------------------------------------
NLS_DATE_FORMAT                DD-MON-RR                                Date format
NLS_DATE_LANGUAGE              AMERICAN                                 Date language
NLS_SORT                       BINARY                                   Linguistic definition
NLS_TIME_FORMAT                HH.MI.SSXFF AM                           Time format
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM                 Time stamp format
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR                       Time with timezone format
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR             Timestamp with timezone format
NLS_DUAL_CURRENCY              $                                        Dual currency symbol
NLS_COMP                       BINARY                                   NLS comparison
NLS_LENGTH_SEMANTICS           BYTE                                     NLS length semantics
NLS_NCHAR_CONV_EXCP            FALSE                                    NLS conversion exception

NAME                           VALUE$                                   COMMENT$
------------------------------ ---------------------------------------- --------------------------------------------
NLS_NCHAR_CHARACTERSET         AL16UTF16                                NCHAR Character set
NLS_RDBMS_VERSION              10.2.0.1.0                               RDBMS version for NLS parameters
GLOBAL_DB_NAME                 DBTEST.REGRESS.RDBMS.DEV.US.ORACLE.COM   Global database name
EXPORT_VIEWS_VERSION           8                                        Export views revision #
DBTIMEZONE                     00:00                                    DB time zone

27 rows selected.