Unicode Collation in Sqlite

Introduction

Collating sequences are used when comparing strings in order to determine which string is greater or if they are equal. The collating sequence can implement different aspects of the comparison, such as case sensitivity or language specific aspects when sorting.

The Sqlite core supports only the most basic collations; BINARY, NOCASE and RTRIM. The NOCASE collation only takes the 26 uppercase ASCII characters into account.

Additional collations can be loaded via the Sqlite extension mechanism.

Sqlite ICU Extension

...

...

References

http://www.sqlite.org/datatype3.html#collation

UnicodeCollation (last edited 2012-11-05 01:25:45 by Thomas Åkesson)