Dictionary Order, Case-insensitive, Uppercase Preference
With this sort order, characters with diacritical marks are treated as different from all other characters (except their corresponding uppercase or lowercase characters). For example:
A = a
Ä = ä
Å = å
a ¹ à ¹ á ¹ â ¹ ä ¹ å
A ¹ Ä ¹ Å
Jose = jose
Jose ¹ José
With this sort order, characters are compared according to the following rules:
-
Uppercase characters are sorted before their corresponding lowercase characters.
-
Uppercase characters with diacritical marks are sorted before their corresponding lowercase characters.
-
Characters with diacritical marks are sorted after characters without diacritical marks.
-
Characters with diacritical marks are sorted in the order they appear in the character set
For example:
A, a, à, á, â, Ä, ä, Å, å