在plsql下设置以下内容:1>. 以sysdba身份进入 2>. update props$ set value$='ZHS16GBK' WHERE NAME='NLS_CHARACTERSET' value的值如下: Oracle NLS_CHARACTERSET value LanguageAR8ISO8859P6 Arabic (ISO)AR8MSWIN1256 Arabic (Windows)NEE8ISO8859P4 Baltic (ISO)BLT8MSWIN1257 Baltic (Windows) windows-1257
EE8PC852 Central European (DOS)EE8ISO8859P2 Central European (ISO)EE8MSWIN1250 Central European (Windows)ZHS16CGB231280 Chinese Simplified (GB2312) gb2312 chinese, csGB2312, csISO58GB231280, GB2312, GB_2312-80, iso-ir-58ZHS16GBK Chinese Simplified (Windows) windows-9361 windows-936ZHT16BIG5 Chinese Traditional big5 csbig5, x-x-big5ZHT16MSWIN950 Chinese Traditional windows-950 ISO2022-CN Chinese iso-2022-cn2 csISO2022CNZHT32EUC Chinese Traditional (EUC-TW) EUC-TW1
ISO2022-JP Japanese (JIS)JA16EUC Japanese (EUC)JA16SJIS Japanese (Shift-JIS)KO16KSC5601 KoreanISO2022-KR Korean (ISO)KO16MSWIN949 Korean (Windows)SE8ISO8859P3 South European (ISO)TH8TISASCII ThaiTR8MSWIN1254 Turkish (Windows)WE8ISO8859P9 Turkish (ISO)UTF8 Universal (UTF-8) utf-8 unicode-1-1-utf-8, unicode-2-0-utf-8, x-unicode-2-0-utf-8VN8MSWIN1258 Vietnamese (Windows)
WE8MSWIN1252 Western Alphabet (windows)WE8ISO8859P1 Western AlphabetWE38PC850 Western Alphabet (DOS)3>. Commit 4>. 只有重新启动Oracle 服务器该设置才会生效。 修改客户端的字符集: 1>. Linux / Unix 修改环境变量NLS_LANG=AMERICAN_AMERICA.[上面设置的value] export NLS_LANG=……2>. Windows dos下set NLS_LANG=…….
<constant name="struts.i18n.encoding" value="GBK"></constant>
这样试试看吧?
oracle10g怎么改编码??
和过滤器能扯上关系么!
2>. update props$ set value$='ZHS16GBK' WHERE NAME='NLS_CHARACTERSET'
value的值如下:
Oracle NLS_CHARACTERSET value
LanguageAR8ISO8859P6
Arabic (ISO)AR8MSWIN1256
Arabic (Windows)NEE8ISO8859P4
Baltic (ISO)BLT8MSWIN1257
Baltic (Windows)
windows-1257
EE8PC852
Central European (DOS)EE8ISO8859P2
Central European (ISO)EE8MSWIN1250
Central European (Windows)ZHS16CGB231280
Chinese Simplified (GB2312)
gb2312
chinese, csGB2312, csISO58GB231280, GB2312, GB_2312-80, iso-ir-58ZHS16GBK
Chinese Simplified (Windows)
windows-9361
windows-936ZHT16BIG5
Chinese Traditional
big5
csbig5, x-x-big5ZHT16MSWIN950
Chinese Traditional
windows-950 ISO2022-CN
Chinese
iso-2022-cn2
csISO2022CNZHT32EUC
Chinese Traditional (EUC-TW)
EUC-TW1
RU8PC866
Cyrillic (DOS)CL8ISO8859P5
Cyrillic (ISO)CL8KOI8R
Cyrillic (KOI8-R)CL8MSWIN1251
Cyrillic Alphabet (Windows)EL8ISO8859P7
Greek (ISO)EL8MSWIN1253
Greek (Windows)
IW8ISO8859P8
Hebrew (ISO)IW8MSWIN1255
Hebrew (Windows)
ISO2022-JP
Japanese (JIS)JA16EUC
Japanese (EUC)JA16SJIS
Japanese (Shift-JIS)KO16KSC5601
KoreanISO2022-KR
Korean (ISO)KO16MSWIN949
Korean (Windows)SE8ISO8859P3
South European (ISO)TH8TISASCII
ThaiTR8MSWIN1254
Turkish (Windows)WE8ISO8859P9
Turkish (ISO)UTF8
Universal (UTF-8)
utf-8
unicode-1-1-utf-8, unicode-2-0-utf-8, x-unicode-2-0-utf-8VN8MSWIN1258
Vietnamese (Windows)
WE8MSWIN1252
Western Alphabet (windows)WE8ISO8859P1
Western AlphabetWE38PC850
Western Alphabet (DOS)3>. Commit
4>. 只有重新启动Oracle 服务器该设置才会生效。
修改客户端的字符集:
1>. Linux / Unix
修改环境变量NLS_LANG=AMERICAN_AMERICA.[上面设置的value]
export NLS_LANG=……2>. Windows
dos下set NLS_LANG=…….