- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2007-02-06 17:10:49
1>. 以sysdba身份进入
2>. update props$ set value$='zhs16gbk'
where name='nls_characterset'
可以使用的value有
ref:
|
oracle
nls_characterset value |
language |
iana preffered mime charset |
iana
additional aliases |
|
ar8iso8859p6 |
arabic (iso) |
iso-8859-6 |
iso_8859-6:1987, iso-ir-127, iso_8859-6,
ecma-114, asmo-708, arabic, csisolatinarabic |
|
ar8mswin1256 |
arabic (windows) |
windows-1256 |
|
|
nee8iso8859p4 |
baltic (iso) |
iso-8859-4 |
csisolatin4, iso-ir-110, iso_8859-4,
iso_8859-4:1988, l4, latin4 |
|
blt8mswin1257 |
baltic (windows) |
windows-1257 |
|
|
ee8pc852 |
central european (dos) |
ibm852 |
cp852, 852, cspcp852 |
|
ee8iso8859p2 |
central european (iso) |
iso-8859-2 |
csisolatin2, iso-ir-101, iso8859-2,
iso_8859-2, iso_8859-2:1987, l2, latin2 |
|
ee8mswin1250 |
central european (windows) |
windows-1250 |
x-cp1250 |
|
zhs16cgb231280 |
chinese simplified (gb2312) |
gb2312 |
chinese, csgb2312, csiso58gb231280, gb2312,
gb_2312-80, iso-ir-58 |
|
zhs16gbk |
chinese simplified (windows) |
windows-9361 |
windows-936 |
|
zht16big5 |
chinese traditional |
big5 |
csbig5, x-x-big5 |
|
zht16mswin950 |
chinese traditional |
windows-950 |
|
|
iso2022-cn |
chinese |
iso-2022-cn2 |
csiso2022cn |
|
zht32euc |
chinese traditional (euc-tw) |
euc-tw1 |
|
|
ru8pc866 |
cyrillic (dos) |
ibm866 |
cp866, 866, csibm866 |
|
cl8iso8859p5 |
cyrillic (iso) |
iso-8859-5 |
csisolatincyrillic, cyrillic,
iso-ir-144, iso_8859-5, iso_8859-5:1988 |
|
cl8koi8r |
cyrillic (koi8-r) |
koi8-r |
cskoi8r, koi |
|
cl8mswin1251 |
cyrillic alphabet (windows) |
windows-1251 |
x-cp1251 |
|
el8iso8859p7 |
greek (iso) |
iso-8859-7 |
csisolatingreek, ecma-118, elot_928, greek, greek8, iso-ir-126, iso_8859-7, iso_8859-7:1987, csisolatingreek |
|
el8mswin1253 |
greek (windows) |
windows-1253 |
|
|
iw8iso8859p8 |
hebrew (iso) |
iso-8859-8 |
csisolatinhebrew, hebrew,
iso-ir-138, iso_8859-8, visual, iso-8859-8 visual, iso_8859-8:1988 |
|
iw8mswin1255 |
hebrew (windows) |
windows-1255 |
|
|
iso2022-jp |
japanese (jis) |
iso-2022-jp |
csiso2022jp |
|
ja16euc |
japanese (euc) |
euc-jp |
cseucpkdfmtjapanese, extended_unix_code_packed_format_for_japanese,
x-euc, x-euc-jp |
|
ja16sjis |
japanese (shift-jis) |
shift_jis |
csshiftjis, cswindows31j, ms_kanji,
shift-jis, x-ms-cp932, x-sjis |
|
ko16ksc5601 |
korean |
ks_c_5601-1987 |
csksc56011987, korean,
ks_c_5601, euc-kr, cseuckr |
|
iso2022-kr |
korean (iso) |
iso-2022-kr |
csiso2022kr |
|
ko16mswin949 |
korean (windows) |
windows-949 |
|
|
se8iso8859p3 |
south european (iso) |
iso-8859-3 |
iso_8859-3, iso_8859-3:1988, iso-ir-109,
latin3, l3, csisolatin3 |
|
th8tisascii |
thai |
tis-620 |
windows-874 |
|
tr8mswin1254 |
turkish (windows) |
windows-1254 |
|
|
we8iso8859p9 |
turkish (iso) |
iso-8859-9 |
latin5, l5, csisolatin5, iso_8859-9,
iso-ir-148, iso_8859-9:1989 |
|
utf8 |
universal (utf-8) |
utf-8 |
unicode-1-1-utf-8,
unicode-2-0-utf-8, x-unicode-2-0-utf-8 |
|
vn8mswin1258 |
vietnamese (windows) |
windows-1258 |
|
|
we8mswin1252 |
western alphabet (windows) |
windows-1252 |
x-ansi |
|
we8iso8859p1 |
western alphabet |
iso-8859-1 |
cp819, ibm819, iso-ir-100,
iso8859-1, iso_8859-1, iso_8859-1:1987, latin1, l1, csisolatin1 |
|
we38pc850 |
western alphabet (dos) |
ibm850 |
cp850, 850, csibm850 |
3>. commit
4>. 只有重新启动oracle 服务器该设置才会生效。
我的测试环境为red hat 9.0 oracle 9.2.0.4
修改客户端的字符集：
1>. linux / unix
修改环境变量nls_lang=american_america.[上面设置的value]
export nls_lang=……
注意该设置只对当前进程有效
2>. windows
set nls_lang=…….