17.10 - Available Collation Sequences - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

The collation sequence for MULTINATIONAL collation can be any one of the following:

  • Teradata Standard Multinational (a two-level comparison based on the Unicode collation standard).

    This is the initial default sequence for any user or session with [SESSION] COLLATION set to MULTINATIONAL.

    It can be altered using the macro CollAddStandard.

  • Norwegian Standard (based on the Norwegian collation sequence).
  • Swedish Standard (based on the Swedish collation sequence).
  • Any one of three predefined Japanese collations:
    • Katakana_Standard
    • Kanji5026_Standard
    • Kanji5035_Standard
  • A site-defined collation sequence.