European Sort Order - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
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 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

ÿ     Ÿ

æ     Æ ø     Ø å     Å