Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateData types and subtypes → New collations
Firebird Home Firebird Home Prev: Character set NONE handling changedFirebird Documentation IndexUp: Data types and subtypesNext: DDL statements

New collations

Added in: 1.0, 1.5, 1.5.1, 2.0

The following table lists the collations added in Firebird. The “Details” column is based on what has been reported in the Release Notes and other documents. The information in this column is probably incomplete; some collations with an empty Details field may still be case insensitive (ci), accent insensitive (ai) or dictionary-sorted (dic).

Table 4.2. Collations new in Firebird

Character set Collation Language Details Added in
ISO8859_1 ES_ES_CI_AI Spanish ci, ai 2.0
PT_BR Brazilian Portuguese ci, ai 2.0
ISO8859_2 CS_CZ Czech   1.0
ISO_HUN Hungarian   1.5
ISO_PLK Polish   2.0
ISO8859_13 LT_LT Lithuanian   1.5.1
UTF8 UCS_BASIC All   2.0
UNICODE All dic 2.0
WIN1250 BS_BA Bosnian   2.0
PXW_HUN Hungarian ci 1.0
WIN_CZ Czech ci 2.0
WIN_CZ_CI_AI Czech ci, ai 2.0
WIN1251 WIN1251_UA Ukrainian and Russian   1.5
WIN1252 WIN_PTBR Brazilian Portuguese ci, ai 2.0
WIN1257 WIN1257_EE Estonian dic 2.0
WIN1257_LT Lithuanian dic 2.0
WIN1257_LV Latvian dic 2.0
KOI8R KOI8R_RU Russian dic 2.0
KOI8U KOI8U_UA Ukrainian dic 2.0


A note on the UTF8 collations

The UCS_BASIC collation sorts in Unicode code-point order: A, B, a, b, á... This is exactly the same as UTF8 with no collation specified. UCS_BASIC was added to comply with the SQL standard.

The UNICODE collation sorts using UCA (Unicode Collation Algorithm): a, A, á, b, B...

Prev: Character set NONE handling changedFirebird Documentation IndexUp: Data types and subtypesNext: DDL statements
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateData types and subtypes → New collations