Firebird collation charts

Home

Locales: IBM i5/OS | Fedora Core 6 | FreeBSD 5.4 | HP-UX 11 | SCO OpenServer 6.0.0 | SGI IRIX 6.5 | SUN OpenSolaris 2008.05 | SUN Solaris 10 Sparc | SUN Solaris 10 x86 | Windows 2000 | Windows XP | Windows Vista

Collations: Firebird collations | MS SQL Server collations | MySQL collations | Oracle sorts | Sybase collations

• Firebird Character Sets and Collations on Stefan Heymann's site.

Collation attributes listed in the "Description" column:

• U - Upper case is sorted before lower case
• L - Lower case is sorted before upper case
• N - Punctuation characters have non-ignorable weighting, i.e. the differences between these characters are of the same importance as differences between letters.
• S - Punctiation characters have shifted weighting, i.e. these characters are of only minor importance.

      Name                                     Last modified      Size  Description
      Parent Directory                                              -   
      HEADER.shtml                             22-Mar-2008 01:06  518   
      fb203.ISO8859_1.DA_DA.html               19-Feb-2009 13:47   34K  U, S. Special characters: Ü, Æ Ä, Ø Ö, Å AA
      fb203.ISO8859_1.DE_DE.html               19-Feb-2009 13:47   34K  L, S.
      fb203.ISO8859_1.DU_NL.html               19-Feb-2009 13:47   34K  L, S. Similar to DE_DE.
      fb203.ISO8859_1.EN_UK.html               19-Feb-2009 13:47   34K  L, S. Similar to DE_DE.
      fb203.ISO8859_1.EN_US.html               19-Feb-2009 13:47   33K  L, N.
      fb203.ISO8859_1.ES_ES.html               19-Feb-2009 13:47   35K  L, S. Special characters: CH, LL, Ñ.
      fb203.ISO8859_1.FI_FI.html               19-Feb-2009 13:47   34K  L, S. Special characters: Ü, Å, Ä Æ, Ö Ø.
      fb203.ISO8859_1.FR_CA.html               19-Feb-2009 13:47   34K  L, S. Similar to DE_DE.
      fb203.ISO8859_1.FR_FR.html               19-Feb-2009 13:47   34K  L, S. Similar to DE_DE.
      fb203.ISO8859_1.IS_IS.html               19-Feb-2009 13:47   34K  L, S. Special characters: Á, Ð, É, Í, Ó, Ú, Ý, Þ, Æ, Ö Ø.
      fb203.ISO8859_1.IT_IT.html               19-Feb-2009 13:47   34K  L, S. Similar to DE_DE.
      fb203.ISO8859_1.NO_NO.html               19-Feb-2009 13:47   34K  L, S. Special characters: Æ, Ø, Å AA.
      fb203.ISO8859_1.PT_BR.html               19-Feb-2009 13:47   33K  L, N. No expansions.
      fb203.ISO8859_1.PT_PT.html               19-Feb-2009 13:47   34K  L, S. Similar to DE_DE.
      fb203.ISO8859_1.SV_SV.html               19-Feb-2009 13:47   34K  L, S. Similar to FI_FI. Special characters: Ü, Å, Ä Æ, Ö Ø.
      fb203.ISO8859_2.CS_CZ.html               19-Feb-2009 13:47   33K  L, N. Special characters: Č, Ř, Š, Ž.
      fb203.ISO8859_2.ISO_HUN.html             19-Feb-2009 13:47   37K  L, N. Special characters: CS, DZ, GY, LY, NY, SZ, TY, ZS.
      fb203.WIN1250.BS_BA.html                 19-Feb-2009 13:47   34K  L, N. Special characters: Č, Ć, Đ, LJ, NJ, Š, Ž
      fb203.WIN1250.PXW_CSY.html               19-Feb-2009 13:47   34K  L, N. Special characters: Č, CH, Ř, Š, Ž.
      fb203.WIN1250.PXW_HUN.html               19-Feb-2009 13:47   37K  L, N. Special characters: CS, DZ, GY, LY, NY, SZ, TY, ZS, all accented letters
      fb203.WIN1250.PXW_HUNDC.html             19-Feb-2009 13:47   37K  L, N. Special characters: CS, DZ, GY, LY, NY, SZ, TY, ZS
      fb203.WIN1250.PXW_PLK.html               19-Feb-2009 13:47   33K  L, N.
      fb203.WIN1250.PXW_SLOV.html              19-Feb-2009 13:47   33K  L, N. Special characters: Č, Ć, Đ, Š, Ž.
      fb203.WIN1250.WIN_CZ.html                19-Feb-2009 13:47   34K  U, N. Special characters: Č, CH, Ř, Š, Ž.
      fb203.WIN1250.WIN_CZ_CI_AI.html          19-Feb-2009 13:47   33K  U, N.
      fb203.WIN1251.PXW_CYRL.html              19-Feb-2009 13:47   33K  L, N.
      fb203.WIN1251.WIN1251_UA.html            19-Feb-2009 13:47   33K  L. N.
      fb203.WIN1252.PXW_INTL.html              19-Feb-2009 13:47   33K  L. N.
      fb203.WIN1252.PXW_INTL850.html           19-Feb-2009 13:47   33K  L. N.
      fb203.WIN1252.PXW_NORDAN4.html           19-Feb-2009 13:47   33K  U. N. Special characters: Ü, Æ Ä, Ø Ö, Å.
      fb203.WIN1252.PXW_PTBR.html              19-Feb-2009 13:47   33K  L. N.
      fb203.WIN1252.PXW_SPAN.html              19-Feb-2009 13:47   34K  L. N. Special characters: CH, LL, Ñ
      fb203.WIN1252.PXW_SWEDFIN.html           19-Feb-2009 13:47   33K  L. N.
      fb203.WIN1253.PXW_GREEK.html             19-Feb-2009 13:47   33K  L. N.
      fb203.WIN1254.PXW_TURK.html              19-Feb-2009 13:47   33K  L. N.
      fb203.WIN1257.WIN1257_EE.html            19-Feb-2009 13:47   33K  L. N. Special characters: Š, Z Ź Ż, Ž, W, Õ, Ä, Ö, Ü
      fb203.WIN1257.WIN1257_LT.html            19-Feb-2009 13:47   33K  L. N. Special characters: Č, Š, Ž
      fb203.WIN1257.WIN1257_LV.html            19-Feb-2009 13:47   33K  L. N. Special characters: Č, Ģ, Ļ, Ņ, Š, Ž