oracle修改字符集
来源:百度文库 编辑:神马文学网 时间:2024/04/29 09:14:10
在plsql下设置以下内容:
1>. 以sysdba身份进入
2>. update props$ set value$='ZHS16GBK' WHERE NAME='NLS_CHARACTERSET'
value的值如下:
Oracle NLS_CHARACTERSET value
Language
AR8ISO8859P6
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-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)
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
Korean
ISO2022-KR
Korean (ISO)
KO16MSWIN949
Korean (Windows)
SE8ISO8859P3
South European (ISO)
TH8TISASCII
Thai
TR8MSWIN1254
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-8
VN8MSWIN1258
Vietnamese (Windows)
WE8MSWIN1252
Western Alphabet (windows)
WE8ISO8859P1
Western Alphabet
WE38PC850
Western Alphabet (DOS)
3>. Commit
4>. 只有重新启动Oracle 服务器该设置才会生效。
修改客户端的字符集:
1>. Linux / Unix
修改环境变量NLS_LANG=AMERICAN_AMERICA.[上面设置的value]
export NLS_LANG=……
2>. Windows
dos下set NLS_LANG=…….