16.20 - Equivalence Classes and Ordering Within Class - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine International Character Set Support

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
User Guide

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