Appendix F: Character Sets and Collation Sequences

Table F.1. Character Sets and Collation Sequences

Character Set	ID	Bytes per Char	Collation	Language
ASCII	2	1	ASCII	English
BIG_5	56	2	BIG_5	Chinese, Vietnamese, Korean
CP943C	68	2	CP943C	Japanese
''	''	''	CP943C_UNICODE	Japanese
CYRL	50	1	CYRL	Russian
''	''	''	DB_RUS	Russian dBase
''	''	''	PDOX_CYRL	Russian Paradox
DOS437	10	1	DOS437	U.S. English
''	''	''	DB_DEU437	German dBase
''	''	''	DB_ESP437	Spanish dBase
''	''	''	DB_FIN437	Finnish dBase
''	''	''	DB_FRA437	French dBase
''	''	''	DB_ITA437	Italian dBase
''	''	''	DB_NLD437	Dutch dBase
''	''	''	DB_SVE437	Swedish dBase
''	''	''	DB_UK437	English (Great Britain) dBase
''	''	''	DB_US437	U.S. English dBase
''	''	''	PDOX_ASCII	Code page Paradox—ASCII
''	''	''	PDOX_SWEDFIN	Swedish / Finnish Paradox
''	''	''	PDOX_INTL	International English Paradox
DOS737	9	1	DOS737	Greek
DOS775	15	1	DOS775	Baltic
DOS850	11	1	DOS850	Latin I (no Euro symbol)
''	''	''	DB_DEU850	German
''	''	''	DB_ESP850	Spanish
''	''	''	DB_FRA850	French
''	''	''	DB_FRC850	French—Canada
''	''	''	DB_ITA850	Italian
''	''	''	DB_NLD850	Dutch
''	''	''	DB_PTB850	Portuguese—Brazil
''	''	''	DB_SVE850	Swedish
''	''	''	DB_UK850	English—Great Britain
''	''	''	DB_US850	U.S. English
DOS852	45	1	DOS852	Latin II
''	''	''	DB_CSY	Czech dBase
''	''	''	DB_PLK	Polish dBase
''	''	''	DB_SLO	Slovak dBase
''	''	''	PDOX_CSY	Czech Paradox
''	''	''	PDOX_HUN	Hungarian Paradox
''	''	''	PDOX_PLK	Polish Paradox
''	''	''	PDOX_SLO	Slovak Paradox
DOS857	46	1	DOS857	Turkish
''	''	''	DB_TRK	Turkish dBase
DOS858	16	1	DOS858	Latin I (with Euro symbol)
DOS860	13	1	DOS860	Portuguese
''	''	''	DB_PTG860	Portuguese dBase
DOS861	47	1	DOS861	Icelandic
''	''	''	PDOX_ISL	Icelandic Paradox
DOS862	17	1	DOS862	Hebrew
DOS863	14	1	DOS863	French—Canada
''	''	''	DB_FRC863	French dBase—Canada
DOS864	18	1	DOS864	Arabic
DOS865	12	1	DOS865	Scandinavian
''	''	''	DB_DAN865	Danish dBase
''	''	''	DB_NOR865	Norwegian dBase
''	''	''	PDOX_NORDAN4	Paradox Norway and Denmark
DOS866	48	1	DOS866	Russian
DOS869	49	1	DOS869	Modern Greek
EUCJ_0208	6	2	EUCJ_0208	Japanese EUC
GB_2312	57	2	GB_2312	Simplified Chinese (Hong Kong, Korea)
GB18030	69	4	GB18030	Chinese
''	''	''	GB18030_UNICODE	Chinese
GBK	67	2	GBK	Chinese
''	''	''	GBK_UNICODE	Chinese
ISO8859_1	21	1	ISO8859_1	Latin I
''	''	''	DA_DA	Danish
''	''	''	DE_DE	German
''	''	''	DU_NL	Dutch
''	''	''	EN_UK	English—Great Britain
''	''	''	EN_US	U.S. English
''	''	''	ES_ES	Spanish
''	''	''	ES_ES_CI_AI	Spanish—case insensitive and + accent-insensitive
	''	''	FI_FI	Finnish
''	''	''	FR_CA	French—Canada
''	''	''	FR_FR	French
''	''	''	FR_FR_CI_AI	French—case insensitive + accent insensitive
''	''	''	IS_IS	Icelandic
''	''	''	IT_IT	Italian
''	''	''	NO_NO	Norwegian
ISO8859_1	''	''	PT_PT	Portuguese
''	''	''	PT_BR	Portuguese—Brazil
''	''	''	SV_SV	Swedish
ISO8859_2	22	1	ISO8859_2	Latin 2—Central Europe (Croatian, Czech, Hungarian, Polish, Romanian, Serbian, Slovak, Slovenian)
''	''	''	CS_CZ	Czech
''	''	''	ISO_HUN	Hungarian—case insensitive, accent sensitive
''	''	''	ISO_PLK	Polish
ISO8859_3	23	1	ISO8859_3	Latin 3—Southern Europe (Malta, Esperanto)
ISO8859_4	34	1	ISO8859_4	Latin 4—Northern Europe (Estonian, Latvian, Lithuanian, Greenlandic, Lappish)
ISO8859_5	35	1	ISO8859_5	Cyrillic (Russian)
ISO8859_6	36	1	ISO8859_6	Arabic
ISO8859_7	37	1	ISO8859_7	Greek
ISO8859_8	38	1	ISO8859_8	Hebrew
ISO8859_9	39	1	ISO8859_9	Latin 5
ISO8859_13	40	1	ISO8859_13	Latin 7—Baltic
''	''	''	LT_LT	Lithuanian
KOI8R	63	1	KOI8R	Russian—dictionary ordering
''	''	''	KOI8R_RU	Russian
KOI8U	64	1	KOI8U	Ukrainian—dictionary ordering
''	''	''	KOI8U_UA	Ukrainian
KSC_5601	44	2	KSC_5601	Korean
''	''	''	KSC_DICTIONARY	Korean—dictionary sort order
NEXT	19	1	NEXT	Coding NeXTSTEP
''	''	''	NXT_DEU	German
''	''	''	NXT_ESP	Spanish
''	''	''	NXT_FRA	French
''	''	''	NXT_ITA	Italian
NEXT	19	1	NXT_US	U.S. English
NONE	0	1	NONE	Neutral code page. Translation to upper case is performed only for code ASCII 97-122. Recommendation: avoid this character set
OCTETS	1	1	OCTETS	Binary character encoding
SJIS_0208	5	2	SJIS_0208	Japanese
TIS620	66	1	TIS620	Thai
''	''	''	TIS620_UNICODE	Thai
UNICODE_FSS	3	3	UNICODE_FSS	All English
UTF8	4	4	UTF8	Any language that is supported in Unicode 4.0
''	''	''	USC_BASIC	Any language that is supported in Unicode 4.0
''	''	''	UNICODE	Any language that is supported in Unicode 4.0
''	''	''	UNICODE_CI	Any language that is supported in Unicode 4.0—Case insensitive
''	''	''	UNICODE_CI_AI	Any language that is supported in Unicode 4.0—Case insensitive and accent insensitive
WIN1250	51	1	WIN1250	ANSI—Central Europe
''	''	''	BS_BA	Bosnian
''	''	''	PXW_CSY	Czech
''	''	''	PXW_HUN	Hungarian—case insensitive, accent sensitive
''	''	''	PXW_HUNDC	Hungarian—dictionary ordering
''	''	''	PXW_HUNDC	Polish
''	''	''	PXW_PLK	Slovak
''	''	''	PXW_SLOV	Slovenian
''	''	''	WIN_CZ	Czech
''	''	''	WIN_CZ_CI	Czech—Case insensitive
''	''	''	WIN_CZ_CI_AI	Czech—Case insensitive and accent insensitive

WIN1251	52	1	WIN1251	ANSI Cyrillic
''	''	''	WIN1251_UA	Ukrainian
''	''	''	PXW_CYRL	Paradox Cyrillic (Russian)
WIN1252	53	1	WIN1252	ANSI—Latin I
''	''	''	PXW_INTL	English International
''	''	''	PXW_INTL850	Paradox multilingual Latin I
''	''	''	PXW_NORDAN4	Norwegian and Danish
''	''	''	PXW_SPAN	Paradox Spanish
''	''	''	PXW_SWEDFIN	Swedish and Finnish
''	''	''	WIN_PTBR	Portuguese—Brazil
WIN1253	54	1	WIN1253	ANSI Greek
''	''	''	PXW_GREEK	Paradox Greek
WIN1254	55	1	WIN1254	ANSI Turkish
''	''	''	PXW_TURK	Paradox Turkish
WIN1255	58	1	WIN1255	ANSI Hebrew
WIN1256	59	1	WIN1256	ANSI Arabic
WIN1257	60	1	WIN1257	ANSI Baltic
''	''	''	WIN1257_EE	Estonian—Dictionary ordering
''	''	''	WIN1257_LT	Lithuanian—Dictionary ordering
''	''	''	WIN1257_LV	Latvian—Dictionary ordering
WIN1258	65	1	WIN1258	Vietnamese