decode_uri

Description

Replace %-encoded escape sequences in a string with unencoded plain text. However, encoded characters in the set #$&+,/:;=?@ are kept encoded. NULL if input contains an invalid encoded sequence.

Return type

string

Domain

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

Categories

Usage

decode_uri( str )

Argument

Type

Required

Multiple

Constant

str

string

Required

Only one

Variable

Examples

make_col d:decode_uri('%32%5E%33%20%3D%20%38%3B')

Decoding the example string results in ‘2^3 %3D 8%3B’ which is different from decode_uri_component.