15.10 - CollationsV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Integrity

DBC

 

View Column

Data Type

Format

Source Table.Column

CollName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

CollationTbl.CollName (UPI)

CollInstall

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

CollationTbl.CollInstall

CollEqvClass

BYTE(256)

NOT NULL

X(512)

CollationTbl.CollEqvClass

CollOrderCS

BYTE(256)

NOT NULL

X(512)

CollationTbl.CollOrderCS

CollOrderUC

BYTE(256)

NOT NULL

X(512)

CollationTbl.CollOrderUC

The DBC.Collations view initially contains five rows:

  • KANJI5026_STANDARD
  • KANJIKATA_STANDARD
  • KANJI5035_STANDARD
  • NORWEGIAN_STANDARD
  • SWEDISH_STANDARD
  • Database administrators can run the CollInstallMulti macro to specify which row in the DBC.Collations view to use as the collation sequence when the user or session COLLATION option is set to MULTINATIONAL. You must reset (initialize) the Teradata Database before the new collation sequence can take effect.

    When you define a new collation with a name other than ‘MULTINATIONAL,’ set the CollInstall flag to N to avoid extra processing during startup.

    The following statement returns the collation information for all collation sequences defined in the Collations view:

    SELECT CollName
       FROM DBC.CollationsV;

    The result is the following list:

    CollName
    ---------------------------
    KANJI5026_STANDARD
    KANJIKATA_STANDARD
    KANJI5035_STANDARD
    NORWEGIAN_STANDARD
    SWEDISH_STANDARD

    For more information about the MULTINATIONAL collation sequence, see International Character Set Support.