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

OpenEdge Release 10.2B

Copyright © 2009 Progress Software Corporation