Differences between revisions 1 and 2
Revision 1 as of 2012-11-05 01:24:30
Size: 672
Comment:
Revision 2 as of 2012-11-05 01:25:45
Size: 687
Comment:
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
== Introduction == Introduction ==
Line 11: Line 11:
== Sqlite ICU Extension == Sqlite ICU Extension ==
Line 16: Line 16:
== == ... ==
Line 19: Line 19:
== References == References ==

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)