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