各种字符集之间的关系

Subsets and Supersets

Table A-11 lists common subset/superset relationships.

Table A-11 Subset-Superset Pairs

Subset	Superset
AR8ADOS710	AR8ADOS710T
AR8ADOS720	AR8ADOS720T
AR8ADOS720T	AR8ADOS720
AR8APTEC715	AR8APTEC715T
AR8ARABICMACT	AR8ARABICMAC
AR8ISO8859P6	AR8ASMO708PLUS
AR8ISO8859P6	AR8ASMO8X
AR8MUSSAD768	AR8MUSSAD768T
AR8MUSSAD768T	AR8MUSSAD768
AR8NAFITHA711	AR8NAFITHA711T
AR8NAFITHA721	AR8NAFITHA721T
AR8SAKHR707	AR8SAKHR707T
AR8SAKHR707T	AR8SAKHR707
BLT8CP921	BLT8ISO8859P13
BLT8CP921	LT8MSWIN921
D7DEC	D7SIEMENS9780X
D7SIEMENS9780X	D7DEC
DK7SIEMENS9780X	N7SIEMENS9780X
I7DEC	I7SIEMENS9780X
I7SIEMENS9780X	IW8EBCDIC424
IW8EBCDIC424	IW8EBCDIC1086
KO16KSC5601	KO16MSWIN949
LT8MSWIN921	BLT8ISO8859P13
LT8MSWIN921	BLT8CP921
N7SIEMENS9780X	DK7SIEMENS9780X
US7ASCII	See Table A-12, "US7ASCII Supersets".
UTF8	AL32UTF8
WE8DEC	TR8DEC
WE8DEC	WE8NCR4970
WE8ISO8859P1	WE8MSWIN1252
WE8ISO8859P9	TR8MSWIN1254
WE8NCR4970	TR8DEC
WE8NCR4970	WE8DEC
WE8PC850	WE8PC858

US7ASCII is a special case because so many other character sets are supersets of it. Table A-12 lists supersets for US7ASCII.

Table A-12 US7ASCII Supersets

Supersets	Supersets	Supersets
AL32UTF8	EE8ISO8859P2	RU8BESTA
AR8ADOS710	EE8MACCES	RU8PC855
AR8ADOS710T	EE8MACCROATIANS	RU8PC866
AR8ADOS720	EE8MSWIN1250	SE8ISO8859P3
AR8ADOS720T	EE8PC852	TH8MACTHAIS
AR8APTEC715	EL8DEC	TH8TISASCII
AR8APTEC715T	EL8ISO8859P7	TR8DEC
AR8ARABICMACS	EL8MACGREEKS	TR8MACTURKISHS
AR8ASMO708PLUS	EL8MSWIN1253	TR8MSWIN1254
AR8ASMO8X	EL8PC437S	TR8PC857
AR8HPARABIC8T	EL8PC851	US8PC437
AR8ISO8859P6	EL8PC869	UTF8
AR8MSWIN1256	ET8MSWIN923	VN8MSWIN1258
AR8MUSSAD768	HU8ABMOD	VN8VN3
AR8MUSSAD768T	HU8CWI2	WE8DEC
AR8NAFITHA711	IN8ISCII	WE8DG
AR8NAFITHA711T	IS8PC861	WE8ISO8859P1
AR8NAFITHA721	IW8ISO8859P8	WE8ISO8859P15
AR8NAFITHA721T	IW8MACHEBREWS	WE8ISO8859P9
AR8SAKHR706	IW8MSWIN1255	WE8MACROMAN8S
AR8SAKHR707	IW8PC1507	WE8MSWIN1252
AR8SAKHR707T	JA16EUC	WE8NCR4970
AZ8ISO8859PE	JA16SJIS	WE8NEXTSTEP
BG8MSWIN	JA16VMS	WE8PC850
BG8PC437S	KO16KSC5601	WE8PC858
BLT8CP921	KO16KSCCS	WE8PC860
BLT8ISO8859P13	KO16MSWIN949	WE8ROMAN8
BLT8MSWIN1257	LA8ISO6937	ZHS16CGB231280
BLT8PC775	LA8PASSPORT	ZHS16GBK
BN8BSCII	LT8MSWIN921	ZHT16BIG5
CDN8PC863	LT8PC772	ZHT16CCDC
CEL8ISO8859P14	LT8PC774	ZHT16DBT
CL8ISO8859P5	LV8PC1117	ZHT16HKSCS
CL8KOI8R	LV8PC8LR	ZHT16MSWIN950
CL8KOI8U	LV8RST104090	ZHT32EUC
CL8ISOIR111	N8PC865	ZHT32SOPS
CL8MACCYRILLICS	NE8ISO8859P10	ZHT32TRIS
CL8MSWIN1251	NEE8ISO8859P4	ZHS32GB18030

在确定字符集之间的关系以后，如果是超集转换的话，可以在mount状态下用如下的命令：

alter database character set internal_use AL32UTF8 ;

来修改数据库的字符集