Contact Us | Site Map
Firebird is used by approximately 1 million of software developers worldwide. High compatibility with industry standards on many fronts makes Firebird the obvious choice for developing interoperable applications for homogeneous and hybrid environments.
Join Firebird!
Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses
Follow Us
Select your media preference
Google+ Twitter Facebook RSS
Newsletter
Subscribe to Firebird’s Newsletter to receive the latest news
Firebird 1.5 Character Sets & Collations

ID Name Bytes
per Char
Collation Language Aliases
2 ASCII 1 ASCII English ASCII7, USASCII
56 BIG_5 2 BIG_5 Chinese, Vietnamese, Korean BIG5, DOS_950, WIN_950
50 CYRL 1 CYRL Russian --
50 -- -- DB_RUS Dbase Russian --
50 -- -- PDOX_CYRL Paradox Russian --
10 DOS437 1 DOS437 English (USA) DOS_437
10 -- -- DB_DEU437 DBase German --
10 -- -- DB_ESP437 DBase Spanish --
10 -- -- DB_FRA437 DBase French --
10 -- -- DB_FIN437 DBase Finnish --
10 -- -- DB_ITA437 DBase Italian --
10 -- -- DB_NLD437 DBase Dutch --
10 -- -- DB_SVE437 DBase Swedish --
10 -- -- DB_UK437 DBase English (UK) --
10 -- -- DB_US437 DBase English (USA) --
10 -- -- PDOX_ASCII Paradox ASCII code page --
10 -- -- PDOX_SWEDFIN Paradox Swedish/Finnish code pages --
10 -- -- PDOX_INTL Paradox International English code page --
9 DOS737 1 DOS737 Greek DOS_737
15 DOS775 1 DOS775 Baltic DOS_775
11 DOS850 1 DOS850 Latin I (no Euro symbol) DOS_850
11 -- -- DB_DEU850 German --
11 -- -- DB_ESP850 Spanish --
11 -- -- DB_FRA850 French --
11 -- -- DB_FRC850 French (Canada) --
11 -- -- DB_ITA850 Italian --
11 -- -- DB_NLD850 Dutch --
11 -- -- DB_PTB850 Portuguese (Brazil) --
11 -- -- DB_SVE850 Swedish --
11 -- -- DB_UK850 English (UK) --
11 -- -- DB_US850 English (USA) --
45 DOS852 1 DOS852 Latin II DOS_852
45 -- -- DB_CSY DBase Czech --
45 -- -- DB_PLK DBase Polish --
45 -- -- DB_SLO DBase Slovakian --
45 -- -- PDOX_PLK Paradox Polish --
45 -- -- PDOX_HUN Paradox Hungarian --
45 -- -- PDOX_SLO Paradox Slovakian --
45 -- -- PDOX_CSY Paradox Czech --
46 DOS857 1 DOS857 Turkish DOS_857
46 -- -- DB_TRK DBase Turkish --
16 DOS858 1 DOS858 Latin I + Euro symbol DOS_858
13 DOS860 1 DOS860 Portuguese DOS_860
13 -- -- DB_PTG860 DBase Portuguese --
47 DOS861 1 DOS861 Icelandic DOS_861
47 -- -- PDOX_ISL Paradox Icelandic --
17 DOS862 1 DOS862 Hebrew DOS_862
14 DOS863 1 DOS863 French (Canada) DOS_863
14 -- -- DB_FRC863 DBase French (Canada) --
18 DOS864 1 DOS864 Arabic DOS_864
12 DOS865 1 DOS865 Nordic DOS_865
12 -- -- DB_DAN865 DBase Danish --
12 -- -- DB_NOR865 DBase Norwegian --
12 -- -- PDOX_NORDAN4 Paradox Norwegian & Danish --
48 DOS866 1 DOS866 Russian DOS_866
49 DOS869 1 DOS869 Modern Greek DOS_869
6 EUCJ_0208 2 EUCJ_0208 EUC Japanese EUCJ
57 GB_2312 2 GB_2312 Simplified Chinese (Hong Kong, PRC) DOS_936, GB2312, WIN_936
21 ISO8859_1 1 ISO8859_1 Latin 1 ANSI, ISO88591, LATIN1
21 -- -- FR_CA French (Canada) --
21 -- -- DA_DA Danish --
21 -- -- DE_DE German --
21 -- -- ES_ES Spanish --
21 -- -- FI_FI Finnish --
21 -- -- FR_FR French --
21 -- -- IS_IS Icelandic --
21 -- -- IT_IT Italian --
21 -- -- NO_NO Norwegian --
21 -- -- DU_NL Dutch --
21 -- -- PT_PT Portuguese --
21 -- -- SV_SV Swedish --
21 -- -- EN_UK English (UK) --
21 -- -- EN_US English (USA) --
22 ISO8859_2 1 ISO8859_2 Latin 2 —  Central European (Croatian, Czech, Hungarian, Polish, Romanian, Serbian, Slovakian, Slovenian) ISO-8859-2, ISO88592, LATIN2
22 -- -- CS_CZ Czech --
22 -- -- ISO_HUN Hungarian --
23 ISO8859_3 1 ISO8859_3 Latin3 — Southern European (Maltese, Esperanto) ISO-8859-3, ISO88593, LATIN3
34 ISO8859_4 1 ISO8859_4 Latin 4 — Northern European (Estonian, Latvian, Lithuanian, Greenlandic, Lappish) ISO-8859-4, ISO88594, LATIN4
35 ISO8859_5 1 ISO8859_5 Cyrillic (Russian) ISO-8859-5, ISO88595
36 ISO8859_6 1 ISO8859_6 Arabic ISO-8859-6, ISO88596
37 ISO8859_7 1 ISO8859_7 Greek ISO-8859-7, ISO88597
38 ISO8859_8 1 ISO8859_8 Hebrew ISO-8859-8, ISO88598
39 ISO8859_9 1 ISO8859_9 Latin 5 ISO-8859-9, ISO88599, LATIN5
40 ISO8859_13 1 ISO8859_13 Latin 7 — Baltic Rim ISO-8859-13, ISO885913, LATIN7
44 KSC_5601 2 KSC_5601 Korean (Unified Hangeul) DOS_949, KSC5601, WIN_949
44 -- -- KSC_DICTIONARY Korean — dictionary order collation --
19 NEXT 1 NEXT NeXTSTEP encoding --
19 -- -- NXT_US English (USA) --
19 -- -- NXT_FRA French --
19 -- -- NXT_ITA Italian --
19 -- -- NXT_ESP Spanish --
19 -- -- NXT_DEU German --
0 NONE 1 NONE Codepage-neutral. Uppercasing limited to ASCII codes 97-122 --
1 OCTETS 1 OCTETS Binary character BINARY
5 SJIS_0208 2 SJIS_0208 Japanese SJIS
3 UNICODE_FSS 3 UNICODE_FSS UNICODE SQL_TEXT, UTF-8, UTF8, UTF_FSS
51 WIN1250 1 WIN1250 ANSI — Central European WIN_1250
51 -- -- PXW_PLK Polish --
51 -- -- PXW_HUN Hungarian --
51 -- -- PXW_CSY Czech --
51 -- -- PXW_HUNDC Hungarian — dictionary sort --
51 -- -- PXW_SLOV Slovakian --
52 WIN1251 1 WIN1251 ANSI — Cyrillic WIN_1251
52 -- -- WIN1251_UA Ukrainian --
52 -- -- PXW_CYRL Paradox Cyrillic (Russian) --
53 WIN1252 1 WIN1252 ANSI — Latin I WIN_1252
53 -- -- PXW_SWEDFIN Swedish & Finnish --
53 -- -- PXW_NORDAN4 Norwegian & Danish --
53 -- -- PXW_INTL English (International) --
53 -- -- PXW_INTL850 Paradox Multi-lingual Latin I --
53 -- -- PXW_SPAN Paradox Spanish --
54 WIN1253 1 WIN1253 ANSI Greek WIN_1253
54 -- -- PXW_GREEK Paradox Greek --
55 WIN1254 1 WIN1254 ANSI Turkish WIN_1254
55 -- -- PXW_TURK Paradox Turkish --
58 WIN1255 1 WIN1255 ANSI Hebrew WIN_1255
59 WIN1256 1 WIN1256 ANSI Arabic WIN_1256
60 WIN1257 1 WIN1257 ANSI Baltic WIN_1257

Home About Firebird Documentation Downloads Community Support Development Case Studies Back to Top
This site and the pages contained within are Copyright © 2000-2014, Firebird Project. Firebird® is a registered trademark of Firebird Foundation Incorporated. Developed by DQ Team.