检查注册表hkey_local_machine\software\oracle目录中的nls_lang的键值,应该和查询
select
tab1.aa||'_'||tab2.bb||'.'||tab3.cc
from
(select VALUE$ aa from sys.props$ where name='NLS_LANGUAGE')tab1,
(select VALUE$ bb from sys.props$ where name='NLS_ISO_CURRENCY')tab2,
(select VALUE$ cc from sys.props$ where name='NLS_CHARACTERSET')tab3
得到的值一致.
select
tab1.aa||'_'||tab2.bb||'.'||tab3.cc
from
(select VALUE$ aa from sys.props$ where name='NLS_LANGUAGE')tab1,
(select VALUE$ bb from sys.props$ where name='NLS_ISO_CURRENCY')tab2,
(select VALUE$ cc from sys.props$ where name='NLS_CHARACTERSET')tab3
得到的值一致.
<2>用select
tab1.aa||'_'||tab2.bb||'.'||tab3.cc
from
(select VALUE$ aa from sys.props$ where name='NLS_LANGUAGE')tab1,
(select VALUE$ bb from sys.props$ where name='NLS_ISO_CURRENCY')tab2,
(select VALUE$ cc from sys.props$ where name='NLS_CHARACTERSET')tab3得到的是
AMERICAN_AMERICA.ZHS16GBK,不知下一步怎么作