17.20 - Equivalence Classes and Ordering Within Class - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Advanced SQL Engine
Teradata Database
Release Number
June 2022
Last Update
Content Type
User Guide
Publication ID
English (United States)

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