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
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
vnq1596660420420.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
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

ÿ     Ÿ

æ     Æ ø     Ø å     Å