16.20 - DBC.CollationsV View Columns - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K

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.