NORMALIZE_STRING

Categories: String

NORMALIZE_STRING

Returns a normalized string in the specified unicode normalization form.

Syntax

NORMALIZE_STRING() → VARCHAR

Examples

NORMALIZE_STRING example

SELECT NORMALIZE_STRING('¼ϐϹℕ⑩','NFKD')
-- 1⁄4βΣN10

Usage Notes

Supported forms:

• Canonical decomposition (NFD)
• Canonical decomposition followed by canonical composition (NFC)
• Compatibility decomposition (NFKD)
• Compatibility decomposition followed by canonical composition (NFKC).