European Sort Order - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™
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

ÿ     Ÿ

æ     Æ ø     Ø å     Å