UNICODE Normalization Form Translations

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Teradata supports translation using the 4 UNICODE normalization forms: NFC, NFD, NFKC, and NFKD, which correspond to the ANSI NORMALIZE function. You can perform these translations using:

  • UNICODE_TO_UNICODE_NFC
  • UNICODE_TO_UNICODE_NFD
  • UNICODE_TO_UNICODE_NFKC
  • UNICODE_TO_UNICODE_NFKD

Because normalization functions can cause errors due to not preserving BMP characters, you should use the TRANSLATE_CHK function to verify a clean translation.