- All lowercase letters are first mapped to their uppercase equivalents unless CASESPECIFIC is specified in the ORDER BY clause or was defined for the column being accessed.
In ANSI session mode, the default is CASESPECIFIC and you must explicitly specify NOT CASESPECIFIC to change this.
- All diacritical forms of the same letter are given the value of the base letter; that is, Ä is given the value of A, Ö is given the value of O, and so forth.
- If two strings produce the same value, the characters are further ordered according to their sort position in their diacritical equivalence class. See the following table.
- Unless the query specifies the DESC sort option, collation is in ascending order.
For more information, see Teradata Vantage™ - Data Types and Literals, B035-1143.
When these rules are applied, the words “abbey,” “Active,” and “adage” are returned in this order,
abbey Active adage
and the names Muller, Handl, Böckh, Mueller, Händl, Bohr, Bock, and Müller are ordered as:
Bock Böckh Bohr Handl Händl Mueller Muller Müller
Equivalence classes and the ordering of diacritical characters in each class are shown in this table. The listed classes are those with characters that have diacritical forms.
European Sort Order | |||||
---|---|---|---|---|---|
A | C | E | I | N | O |
a A à À á Á â Â ã Ã ä Ä |
c C ç Ç |
e E è È é É ê Ê ë Ë |
i I í Ì ì Í î Î ï Ï |
n N ñ Ñ |
o O ò Ò ó Ó ô Ô õ Õ ö Ö o O |
S | U | Y | AE | O slash | A ring |
s S β |
u U ù Ù ú Ú û Û (U tilde) ü Ü |
y Y ÿ Ÿ |
æ Æ | ø Ø | å Å |