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 .
| Character | Hexadecimal Value | |||
|---|---|---|---|---|
| Teradata Internal Value | CollEqv Class | CollOrder Case-specific | 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 |