16.10 - DBC.CollationsV View Columns - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

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 Data Dictionary.