Skip to main content
Version: 24.3.x

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).