看下面演示與分析
SQL> select * from nls_database_parameters;
PARAMETER VALUE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS
NLS_CHARACTERSET AL
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH
PARAMETER VALUE
NLS_TIMESTAMP_FORMAT DD
NLS_TIME_TZ_FORMAT HH
NLS_TIMESTAMP_TZ_FORMAT DD
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL
NLS_RDBMS_VERSION
windows客戶機上
H:\Users\LuoTaoyang>chcp
活動代碼頁:
H:\Users\LuoTaoyang>set NLS_LANG=American_America
SQL> DESC chartest;
Name Null? Type
ID NUMBER(
NAME VARCHAR
SQL> insert into chartest values(
SQL> SELECT * from chartest;
ID NAME
SQL> select id
ID
DUMP(NAME
Typ=
#
H:\Users\LuoTaoyang>set NLS_LANG=American_America
SQL> select * from chartest;
ID NAME
#出現亂碼是因為此時Oracle客戶端字符集與Oracle主字符集相同
From:http://tw.wingwit.com/Article/program/Oracle/201311/18495.html