操作系统是啥sys 连接上去select * from nls_database_parameters看字符集是啥
是win2000 的系统 PARAMETER --------------------------------------- VALUE --------------------------------------- NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $ PARAMETER --------------------------------------- VALUE --------------------------------------- NLS_ISO_CURRENCY AMERICANLS_NUMERIC_CHARACTERS .,NLS_CHARACTERSET WE8MSWIN1252 PARAMETER --------------------------------------- VALUE --------------------------------------- NLS_CALENDAR GREGORIANNLS_DATE_FORMAT DD-MON-RRNLS_DATE_LANGUAGE AMERICAN 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_COMP BINARYNLS_LENGTH_SEMANTICS BYTENLS_NCHAR_CONV_EXCP FALSE PARAMETER --------------------------------------- VALUE --------------------------------------- NLS_NCHAR_CHARACTERSET AL16UTF16NLS_RDBMS_VERSION 9.2.0.1.0 已选择20行
字符集出问题了,WE8MSWIN1252 要是库不重要就重建吧,重建的时候选ZHS16GBK
是你的客户端和你的服务端字符集不一致导致,在你的客户端改变一下字符集(这是改注册表的,你把其中之一存成xxx.reg,双击,两种都试试,看看那个好就是好的):1. 英文字符集 Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0] "NLS_LANG"="AMERICAN_AMERICA.US7ASCII"[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME1] "NLS_LANG"="AMERICAN_AMERICA.US7ASCII2. 中文字符集 Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0] "NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME1] "NLS_LANG"="SIMPLIFIED CHINESE_
PARAMETER
---------------------------------------
VALUE
---------------------------------------
NLS_LANGUAGE
AMERICANNLS_TERRITORY
AMERICANLS_CURRENCY
$
PARAMETER
---------------------------------------
VALUE
---------------------------------------
NLS_ISO_CURRENCY
AMERICANLS_NUMERIC_CHARACTERS
.,NLS_CHARACTERSET
WE8MSWIN1252
PARAMETER
---------------------------------------
VALUE
---------------------------------------
NLS_CALENDAR
GREGORIANNLS_DATE_FORMAT
DD-MON-RRNLS_DATE_LANGUAGE
AMERICAN
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_COMP
BINARYNLS_LENGTH_SEMANTICS
BYTENLS_NCHAR_CONV_EXCP
FALSE
PARAMETER
---------------------------------------
VALUE
---------------------------------------
NLS_NCHAR_CHARACTERSET
AL16UTF16NLS_RDBMS_VERSION
9.2.0.1.0
已选择20行
Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"NLS_LANG"="AMERICAN_AMERICA.US7ASCII"[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME1]
"NLS_LANG"="AMERICAN_AMERICA.US7ASCII2. 中文字符集
Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME1]
"NLS_LANG"="SIMPLIFIED CHINESE_