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.