Collation-Charts.ORG

Introduction

The goal of this project is to provide information about how various pieces of software (e.g. operating systems, DBMS and others) sort textual data, in the form of easy-to-read charts.

The project aims to help developers in writing portable applications which have to deal with linguistic sorting, as well as to migrate between various operating systems and DBMSs more easily.

We'll also be collecting links to other projects aiming to solve migration or portability problems related to linguistic sorting and searching.

News

• Nov 14, 2010. Collations charts for IBM's International Components for Unicode libary ICU-4.4.2 have been added.
• Dec 2, 2009. An updated version of the Croatian collation patch for MySQL-5.1 is available. It works a little bit more accurate when optimizing a LIKE query for UCS2 columns, in case of non-ASCII contractions:

    SELECT a FROM t1 WHERE a LIKE 'dž%';
  

  The previous version could potentially lose some rows.
• Nov 27, 2009. An article about adding Croatian Unicode collations for MySQL-5.1 is available, including a patch for MySQL-5.1 sources.
• Dec 10, 2007. The site has been opened.

DBMS collation charts

• Firebird collations (v.2.0.3)
• MS SQL Server collations
• MySQL collations (v.6.0.4)
• Oracle sorts (10g)
• Sybase collations (ASE 15.0)

Operating system locale charts

• 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

Charts for libraries

• IBM ICU-4.4.2 collations

• How to add a MySQL collation - instructions how to add new collations into MySQL without recompiling the server.
• Unicode collation charts - charts for the Unicode collation algorithm (UCA) with its default (language-neutral) collation element table (DUCET).
• Vietnamese Unicode FAQ and collation chart.
• Mimer collation charts.
• pg_collkey - using UTF-8 collations for PostgreSQL per column and per expression level.

About