分类： 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=…….
