URL_DECODE

​

Syntax

​

Scalar

url_decode(value)

​

Arguments

​

Returns

• Type: STRING
• Possible values: The encoded or decoded string.
• NULL behavior: Returns NULL for NULL input.

​

Properties

​

Usage notes

• Encoding maps spaces to plus signs; decoding maps plus signs to spaces.

​

Examples

​

Typical behavior

SELECT url_decode('a+b%2Bc') AS "value";

​

Decode UTF-8 text

SELECT url_decode('%E7%8C%AB') AS decoded;

​

Limitations

• Malformed percent sequences or invalid decoded UTF-8 raise an execution error.