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

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
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