Mimer SQL Unicode Collation Chart Help


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.