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.