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