InterBase Character Sets and Collation Orders

Go Up to Character Sets and Collation Orders

The following table lists each character set that can be used in InterBase. For each character set, the minimum and maximum number of bytes used to store each character is listed, and all collation orders supported for that character set are also listed. The first collation order for a given character set is that default collation of the set, the one that is used if no COLLATE clause specifies an alternative order.

Character sets and collation orders
Character set	Char. set ID	Max. char. size	Min. char. size	Collation orders
`ASCII`	2	1 byte	1 byte	`ASCII`
`BIG_5`	56	2 bytes	1 byte	`BIG_5`
`CYRL`	50	1 byte	1 byte	`CYRL` `DB_RUS` `PDOX_CYRL`
`DOS437`	10	1 byte	1 byte	`DOS437` `DB_DEU437` `DB_ESP437` `DB_FIN437` `DB_FRA437` `DB_ITA437` `DB_NLD437` `DB_SVE437` `DB_UK437` `DB_US437` `PDOX_ASCII` `PDOX_INTL` `PDOX_SWEDFIN`
`DOS850`	11	1 byte	1 byte	`DOS850` `DB_DEU850` `DB_ESP850` `DB_FRA850` `DB_FRC850` `DB_ITA850` `DB_NLD850` `DB_PTB850` `DB_SVE850` `DB_UK850` `DB_US850`
`DOS852`	45	1 byte	1 byte	`DOS852` `DB_CSY` `DB_PLK` `DB_SLO` `PDOX_CSY` `PDOX_HUN` `PDOX_PLK` `PDOX_SLO`
`DOS857`	46	1 byte	1 byte	`DOS857` `DB_TRK`
`DOS860`	13	1 byte	1 byte	`DOS860` `DB_PTG860`
`DOS861`	47	1 byte	1 byte	`DOS861` `PDOX_ISL`
`DOS863`	14	1 byte	1 byte	`DOS863` `DB_FRC863`
`DOS865`	12	1 byte	1 byte	`DOS865` `DB_DAN865` `DB_NOR865` `PDOX_NORDAN4`
`EUCJ_0208`	6	2 bytes	1 byte	`EUJC_0208`
`GB_2312`	57	2 bytes	1 byte	`GB_2312`
`ISO8859_1`	21	1 byte	1 byte	`ISO8859_1` CC_ESPLAT1 CC_PTBRLAT1 `DA_DA` `DE_DE` `DU_NL` `EN_UK` `EN_US` `ES_ES` `FI_FI` `FR_CA` `FR_FR` `IS_IS` `IT_IT` `NO_NO` `PT_PT` `SV_SV`
`ISO8859_2`	22	1 byte	1 byte	`ISO8859_2` `CS_CZ` `PL_PL`
`ISO8859_15`	39	1 byte	1 byte	`ISO8859_15` `DA_DA9` `DE_DE9` `DU_NL9` `EN_UK9` `EN_US9` `ES_ES9` `FI_FI9` `FR_CA9` `FR_FR9` `IS_IS9` `IT_IT9` `NO_NO9` `PT_PT9` `SV_SV9`
KO18R	58	1 byte	1 byte	RU_RU
`KSC_5601`	44	2 bytes	1 byte	`KSC_5601` `KSC_DICTIONARY`
`NEXT`	19	1 byte	1 byte	`NEXT` `NXT_DEU` `NXT_FRA` `NXT_ITA` `NXT_US`
`NONE`	0	1 byte	1 byte	`NONE`
`OCTETS`	1	1 byte	1 byte	`OCTETS`
`SJIS_0208`	5	2 bytes	1 byte	`SJIS_0208`
UNICODE_BE UCS2BE	8	2 bytes	2 bytes	N/A at this time
`UNICODE_FSS`	3	3 bytes	1 byte	`UNICODE_FSS`
UNICODE_LE UCS2LE	64	2 byte	2 bytes	N/A
UTF_8	59	4 byte	1 bytes	N/A at this time.
`WIN1250`	51	1 byte	1 byte	`WIN1250` `PXW_CSY` `PXW_HUNDC` `PXW_PLK` `PXW_SLOV`
`WIN1251`	52	1 byte	1 byte	`WIN1251` `PXW_CYRL`
`WIN1252`	53	1 byte	1 byte	`WIN1252` `PXW_INTL` `PXW_INTL850` `PXW_NORDAN4` `PXW_SPAN` `PXW_SWEDFIN`
`WIN1253`	54	1 byte	1 byte	`WIN1253` `PXW_GREEK`
`WIN1254`	55	1 byte	1 byte	`WIN1254` `PXW_TURK`

Topics

Advance To:

Character Set Storage Requirements (Language Reference Guide)