Defining Your Own Collation Sequence | Teradata Vantage - Defining Your Own Collation Sequence - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ywb1588027283948.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.