17.10 - DBC.CollationsV View Columns - 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)

The name, attributes, and use of each column in DBC.CollationsV are defined as follows.

Column Name Data Type Description
CollName VARCHAR(128) NOT NULL Enter any legal name except MULTINATIONAL.

When executed, the CollInstallMulti macro accepts any legal name other than MULTINATIONAL.

CollInstall CHAR(1) NOT NULL Enter the letter N.

When executed, CollInstallMulti inserts a Y indicating that this row is to be installed.

CollEqvClass BYTE (256) BETWEEN 0x00 AND 0xFF NOT NULL Specify, for each character, the value of its equivalent class.

For standard Japanese collations, each value in this field must be 0x00.

CollOrderCS BYTE (256) BETWEEN 0x00 AND 0xFF NOT NULL Specify, for each character, the relative order of the character within its class for case-specific comparison.
CollOrderUC BYTE (256) BETWEEN 0x00 AND 0xFF NOT NULL Specify, for each character, the relative order of the character within its class for uppercase comparison.

For more information about DBC.CollationsV, see Teradata Vantage™ - Data Dictionary, B035-1092.