oracle 乱码问题非常急大家帮忙

显示全部楼层 · 2009-3-10 21:19:05

Copyright (c) 1982, 2005, Oracle.All rights reserved.

???:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> set line 150
SQL> show parameter nls
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
nls_calendar
string
nls_comp
string
nls_currency
string
nls_date_format
string
nls_date_language
string
nls_dual_currency
string
nls_iso_currency
string
nls_language
stringSIMPLIFIED CHINESE
nls_length_semantics
stringBYTE
nls_nchar_conv_excp
stringFALSE
nls_numeric_characters
string
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
nls_sort
string
nls_territory
stringCHINA
nls_time_format
string
nls_time_tz_format
string
nls_timestamp_format
string
nls_timestamp_tz_format
string
SQL> create table test(name varchar2(10));
?????
SQL> insert into test values('库');
??? 1 ??
SQL> commit;
?????
SQL> select * from test;
NAME
----------
??
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
PARAMETER
VALUE
------------------------------ --------------------------------------------------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMATDD-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 UTF8
NLS_RDBMS_VERSION
10.2.0.1.0
???20??
SQL> host cat /etc/sysconfig/i18n
LANG="zh_CN.GBK"
LANGUAGE="zh_CN.GB18030:zh_CN.GB2312:zh_CN"
SUPPORTED="en_US.UTF-8:en_US:en:zh_CN.GB18030:zh_CN:zh:zh_TW.big5:zh_TW:zh:ja_JP.UTF-8:ja_JP:ja:ko_KR.eucKR:ko_KR:ko"
SYSFONT="lat0-sun16"
SYSFONTACM="8859-15"
SQL> host echo "中国"

中国
SQL> show user
USER ? "SYS"
SQL> show parameter nls_lang
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
nls_language
stringSIMPLIFIED CHINESE
SQL> host echo nls_lang
nls_lang
SQL> show parameter nls
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
nls_calendar
string
nls_comp
string
nls_currency
string
nls_date_format
string
nls_date_language
string
nls_dual_currency
string
nls_iso_currency
string
nls_language
stringSIMPLIFIED CHINESE
nls_length_semantics
stringBYTE
nls_nchar_conv_excp
stringFALSE
nls_numeric_characters
string
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
nls_sort
string
nls_territory
stringCHINA
nls_time_format
string
nls_time_tz_format
string
nls_timestamp_format
string
nls_timestamp_tz_format
string
SQL> host echo $NLS_LANG

SQL>
为什么是？的乱码呢，请大家帮忙啊万分感谢

千问 · 2009-3-10 21:19:05

进入SQLPLUS之前，执行：
export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

千问 · 2009-3-10 21:19:05

解决了，谢谢

千问 · 2009-3-10 21:19:05

我昏

千问 · 2009-3-10 21:19:05

在.profie中增加export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

千问 · 2009-3-10 21:19:05

退出重登录，或者执行一下.profile使配置生效。

oracle 乱码问题 非常急 大家帮忙

oracle 乱码问题非常急大家帮忙