Returns the normalized form of a character string based on the specified Unicode normalization form.
Syntax
NORMALIZE ( string , normalization-form )
string
The source string to normalize. The value may be of type CHARACTER or LONGCHAR.
If the string is a CHARACTER value, -cpinternal must be set to UTF-8. If the string is a LONGCHAR value, its code page can be any form of Unicode (for example, UTF-8, UTF-16, or UTF-32). This function returns a value of the same data type as the source string.
normalization-form
A character expression that evaluates to one of the following Unicode normalization forms:
NFD — Canonical Decomposition
NFC — Canonical Decomposition, followed by Canonical Composition
NFKD — Compatibility Decomposition
NFKC — Compatibility Decomposition, followed by Canonical Composition
NFD — Canonical Decomposition