Dictionary Order, Case-insensitive

This is the default sort order. With this sort order:

• 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 sorted 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 in which they appear in the character set.

For example:

A, a, à, á, â, Ä, ä, Å, å

a, A, à, á, â, Ä, ä, Å, å

A, a, à, á, â, ä, Ä, Å, å