查看字符集

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

 

SQL> select * from database_properties;

rows will be truncated

 

 

PROPERTY_NAME                  PROPERTY_VALUE

------------------------------ --------------------------------------------------------------------DICT.BASE                      2

DEFAULT_TEMP_TABLESPACE        TEMP

DEFAULT_PERMANENT_TABLESPACE   USERS

DBTIMEZONE                     +08:00

DEFAULT_TBS_TYPE               SMALLFILE

NLS_LANGUAGE                   SIMPLIFIED CHINESE

NLS_TERRITORY                  CHINA

NLS_CURRENCY                   ?

NLS_ISO_CURRENCY               CHINA

NLS_NUMERIC_CHARACTERS         .,

NLS_CHARACTERSET               ZHS16GBK

NLS_CALENDAR                   GREGORIAN

NLS_DATE_FORMAT                DD-MON-RR

NLS_DATE_LANGUAGE              SIMPLIFIED CHINESE

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_COMP                       BINARY

NLS_LENGTH_SEMANTICS           BYTE

NLS_NCHAR_CONV_EXCP            FALSE

NLS_NCHAR_CHARACTERSET         AL16UTF16

NLS_RDBMS_VERSION              10.2.0.5.0

GLOBAL_DB_NAME                 TJYDXC

EXPORT_VIEWS_VERSION           8

WORKLOAD_CAPTURE_MODE

NO_USERID_VERIFIER_SALT        2EE053DA5CC222B1604127C46F0C4B7B

 

29 rows selected.

 

--数据库的字符集是ZHS16GBK

 

 

 

 

SQL> select * from nls_database_parameters;

 

 

PARAMETER                      VALUE

------------------------------ --------------------------------------------------------------------NLS_LANGUAGE                   SIMPLIFIED CHINESE

NLS_TERRITORY                  CHINA

NLS_CURRENCY                   ?

NLS_ISO_CURRENCY               CHINA

NLS_NUMERIC_CHARACTERS         .,

NLS_CHARACTERSET               ZHS16GBK

NLS_CALENDAR                   GREGORIAN

NLS_DATE_FORMAT                DD-MON-RR

NLS_DATE_LANGUAGE              SIMPLIFIED CHINESE

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_COMP                       BINARY

NLS_LENGTH_SEMANTICS           BYTE

NLS_NCHAR_CONV_EXCP            FALSE

NLS_NCHAR_CHARACTERSET         AL16UTF16

NLS_RDBMS_VERSION              10.2.0.5.0

 

20 rows selected.

 

 

-- 客户端的字符集是ZHS16GBK

 

 

[ora10g@db ~]$ echo $LANG
AMERICAN_AMERICA.ZHS16GBK
[ora10g@db ~]$ echo $NLS_LANG

 

 

[ora10g@db ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[ora10g@db ~]$ sqlplus / as sysdba