17.05 - European Sort Order - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)
The sort order uses a two-level comparison that involves the following rules.
  • 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 table below.
  • 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

ÿ     Ÿ

æ     Æ ø     Ø å     Å