Collation Sequences | International Character Set Support | Teradata Vantage - Collation Sequences - Teradata Vantage - Database Engine 20

International Character Set Support

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Publication Date
June 2025
Content Type
Configuration
User Guide
Publication ID
B035-1125-200K
ft:locale
en-US
ft:lastEdition
2025-08-28
dita:mapPath
jun1747160330269.ditamap
dita:ditavalPath
pny1626732985837.ditaval
ft:sourceId
dita
dita:id
hqj1472245413611
lifecycle
latest
Product Category
Teradata Vantage™

Collations control character ordering and comparison operations during Vantage sessions.

Collations are designed as single level or two level. A two-level collation orders character strings according to a two-level comparison.

Characters are first partitioned into equivalence classes that have the same collating value. The relative ordering of classes and characters within a class is significant.

Comparisons obey the following rules:
  • All characters in a class have the same collation value.
  • A character from class i is less than any character from class i+1.

The process is as follows:

  1. Convert characters in the strings to be compared into equivalence classes.
  2. Compare the strings.
    IF the strings are… THEN processing …
    not equal stops.
    equal continues.
  3. Order characters within each class using criteria defined for the collation sequence, and compare.

The MULTINATIONAL Norwegian standard collation sequence is an example of a two-level collation.