URL_DECODE()

All functions > STRING > URL_DECODE()

Decodes a percent-encoded string (RFC 3986).

Signatures

Returns: Decoded string

URL_DECODE(encoded: VARCHAR) → VARCHAR

Notes

• %HH sequences become the corresponding bytes interpreted as text
• Malformed percent-sequences or encoding issues fail at run time
• Returns NULL if the input is NULL (use NULL(VARCHAR); bare NULL fails inference)
• Inverse of URL_ENCODE for typical round trips

See also

• String functions

Examples

SELECT
    f1 := URL_DECODE('a%20b'), -- Decode spaces
    f2 := URL_DECODE(''), -- Empty string
    f3 := URL_DECODE(NULL(VARCHAR)) -- NULL yields NULL
;