NORMALIZE function

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

NONE — Returns the source string unchanged