16.20 - Equivalence Classes and Ordering Within Class - 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 following table shows the internal values of the characters b, B, c, C, ç, Ç, d and D, and their corresponding values in CollEqvClass, CollOrderCS, and CollOrderUC.

In this table, the values assigned to the equivalence class of b, c, and d are 0x62, 0x63, and 0x64, respectively. This assures that b sorts before c, and c before d. The case-specific (CollOrderCS) value for c is 0x00, and the case-specific value for C is 0x01. This assures that, using the second-level comparison, c sorts before C.

For details on ordering characters within classes as performed by the Teradata Standard Multinational collation, see “ORDER BY Clause” in “The SELECT Statement” in Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .

Character Hexadecimal Value
Teradata Internal Value CollEqv Class CollOrder Casespecific CollOrder Uppercase
b 0x62 0x62 0x00 0x01
B 0x42 0x62 0x01 0x01
c 0x63 0x63 0x00 0x01
C 0x43 0x63 0x01 0x01
ç 0xE7 0x63 0x02 0x01
Ç 0xC7 0x63 0x03 0x01
d 0x64 0x64 0x00 0x01
D 0x44 0x64 0x01 0x01