Dictionary Order, Case-insensitive

This is the default sort order. With this sort order, characters are compared according to the following rules:

• Uppercase and lowercase characters are treated as equivalent.
• 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 not given sorting preference over their corresponding lowercase characters (they can appear before or after them).
• Uppercase characters with diacritical marks are not given sorting preference over their corresponding lowercase characters (they can appear before or after them).
• 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, à, á, â, Ä, ä, Å, å
a, A, à, á, â, Ä, ä, Å, å
A, a, à, á, â, ä, Ä, Å, å