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.