17.10 - Example: Teradata Standard Multinational Collation Equivalence Class - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

As an example using Teradata Standard Multinational collation, consider the following characters: b, B, c, C, ç, Ç, d and D.

Teradata Standard Multinational collation considers these characters … To be in the following equivalence class …
b

B

B
c

C

ç

Ç

C
d

D

D
Within the equivalence class of … The case-specific ordering is …
B
  1. b
  2. B
C
  1. c
  2. C
  3. ç
  4. Ç
D
  1. d
  2. D