decode_uri_component

Description

Replace all %-encoded escape sequences in a string with unencoded plain text.

Returns NULL if input contains an invalid encoded sequence.

See also decode_uri, decode_base64.

Return type

string

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

decode_uri_component(str)

Argument

Type

Optional

Repeatable

Restrictions

str

string

no

no

none

Examples

make_col dc:decode_uri_component('%32%5E%33%20%3D%20%38%3B')

The result of decoding the given string is ‘2^3 = 8;’ which is different from decode_uri.