The collation charts lists Unicode characters in ascending collation order. The color of the cell indicates the strength of the difference between that character and the previous character in the chart, as follows:
| Contraction | Expansion | Contraction and expansion |
||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| a 0061 |
ch 0063 0068 |
Primary difference | ||||||||
| å 00E5 |
œ 0153 |
ヵー 30F5 30FC |
Secondary difference | |||||||
| Å 00C5 |
CH 0043 0048 |
Π0152 |
かー 304B 30FC |
Tertiary difference | ||||||
| Å 212B |
カー 30AB 30FC |
Quarternary difference or no difference |
||||||||
If tool-tips are enabled in your browser, then if you pause the mouse over any cell, you will see the Unicode character name(s) followed by the sort key(s). Each sort key is represented as [xxxx.yyy.zz], where xxxx is the primary weight, yyy is the secondary weight, and zz is the tertiary weight.
Contraction: Two or more characters are sorted as one character.
Expansion: One character is sorted as two or more characters.
For help on using collations in SQL statements, please see the collations section in the Mimer SQL User's manual. You can also find an article about collations here.