16.20 - Defining Your Own Collation Sequence - 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

To create your own collation sequence, define for each character of the alphabet the hexadecimal representation for each of the following:

  • The equivalence class
  • The casespecific value
  • The uppercase value

It is useful to have the hexadecimal representation for the Teradata Database internal value of the character so that the preceding items can be placed in the appropriate position within the defining byte string, as shown in Example of Installing a Japanese Character Standard Collation.

Each group of values is inserted into a column in one row of DBC.CollationsV.

Site-defined collations are valid only for single-byte characters.