sqlplus 操作中的提示内容为???
这里是字符集的信息:
export
declare -x LANG="zh_CN.UTF-8"
 
视图V$NLS_PARAMETERS
~~~~~~~~~~~~~~~~~~~~
select    *    from    V$NLS_PARAMETERS
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_LANGUAGE
SIMPLIFIED CHINESENLS_TERRITORY
CHINANLS_CURRENCY
?
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_ISO_CURRENCY
CHINANLS_NUMERIC_CHARACTERS
.,NLS_CALENDAR
GREGORIAN
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_DATE_FORMAT
DD-MON-RRNLS_DATE_LANGUAGE
SIMPLIFIED CHINESENLS_CHARACTERSET
ZHS16GBK
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_SORT
BINARYNLS_TIME_FORMAT
HH.MI.SSXFF AMNLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY
?
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_NCHAR_CHARACTERSET
AL16UTF16NLS_COMP
BINARYNLS_LENGTH_SEMANTICS
BYTE
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_NCHAR_CONV_EXCP
FALSE
???19??
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
用户环境
select userenv('language') from dual;USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
这里是 我的插入和查询操作
insert into dept values(50,'中文部门','中文')select * from dept;    DEPTNO DNAME          LOC
---------- -------------- -------------
        50 ????????????   ??????
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
网上有些解决方案,我照着改了
在 .bash_profile中添加了如下
export LANG=Zh_CN.GBK
export NLS_LANG="Simplified Chinese_china".ZHS16GBK
并且export显示已经生效
在登录sqlplus显示奇怪的字符,复制下来就是这样
shutdown immediate;\uffff\uffff\uffff\u077f\uffff\uffff\u047e\uffff\uffff\u0631\u0561\uffff
\uffff\u047e\uffff\u0436\uffff\uffff\uffff\uffff\uffff\u077f\u2863
ORACLE \uffff\uffff\uffff\uffff\uffff\u047e\uffff\uffff\u0631\u0561\uffff
请问谁明白这个怎么回事啊??