17.20 - Customizing the Defined Collations - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Advanced SQL Engine
Teradata Database
Release Number
June 2022
Last Update
Content Type
User Guide
Publication ID
English (United States)

A defined collation is active for all server character sets, but they are not applied equally.

You can change the MULTINATIONAL collation for all 256 characters in LATIN, and this definition holds true for those characters whether they occur in GRAPHIC, KANJISJIS, or UNICODE. Note that KANJISJIS and UNICODE have many more characters than LATIN and that the “extra” characters continue to follow the default multinational collation rules.

The collation is two level, which, in the following case specific example, allows you to specify a collation that always produces the following ordering:

  1. aa
  2. Aa
  3. ab
  4. Ab

A single-level, case blind collation might give that answer sometimes, but could theoretically also produce several other orderings, such as the following, on consecutive queries:

  1. Aa
  2. aa
  3. ab
  4. Ab