InterBase Character Sets
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 symbol 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 implicit collation of the set, the one that is used if no COLLATE
clause specifies an alternative order. The implicit collation order cannot be specified in the COLLATE
clause.
Collation names of the form WINxxxx are defined by Microsoft, those of the form DB_xxx are dBASE, and those that start with PDOX or PXW are Paradox. Collation names of the form AA-BB are ISO collations: AA is the language, BB is the country.
Character set | Character set ID |
Maximum character size |
Minimum character 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 |
DOS437 |
10 |
1 byte |
1 byte |
DOS437 |
DOS850 |
11 |
1 byte |
1 byte |
DOS850 |
DOS852 |
45 |
1 byte |
1 byte |
DOS852 |
DOS857 |
46 |
1 byte |
1 byte |
DOS857 |
DOS860 |
13 |
1 byte |
1 byte |
DOS860 |
DOS861 |
47 |
1 byte |
1 byte |
DOS861 |
DOS863 |
14 |
1 byte |
1 byte |
DOS863 |
DOS865 |
12 |
1 byte |
1 byte |
DOS865 |
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_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 CC_PTBRLAT9 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 |
KOI8R |
58 |
1 byte |
1 byte |
KOI8R RU_RU |
KSC_5601 |
44 |
2 bytes |
1 byte |
KSC_5601 KSC_DICTIONARY |
NEXT |
19 |
1 byte |
1 byte |
NEXT |
NONE |
0 |
1 byte |
1 byte |
NONE |
OCTETS |
1 |
1 byte |
1 byte |
OCTETS |
SJIS_0208 |
5 |
2 bytes |
1 byte |
SJIS_0208 |
UNICODE_FSS |
3 |
3 bytes |
1 byte |
UNICODE_FSS |
UNICODE_BE |
8 |
2 bytes |
2 bytes |
N/A at this time |
UNICODE_LE |
64 |
2 byte |
2 bytes |
N/A |
UTF_8 |
59 |
4 bytes |
1 byte |
N/A at this time. |
WIN1250 |
51 |
1 byte |
1 byte |
WIN1250 |
WIN1251 |
52 |
1 byte |
1 byte |
WIN1251 |
WIN1252 |
53 |
1 byte |
1 byte |
WIN1252 CC_PTBRWIN |
WIN1253 |
54 |
1 byte |
1 byte |
WIN1253 |
WIN1254 |
55 |
1 byte |
1 byte |
WIN1254 |