TRY_URL_DECODE

​

Syntax

​

Scalar

try_url_decode(value)

​

Arguments

​

Returns

• Type: STRING
• Possible values: The encoded or decoded string.
• NULL behavior: Returns NULL for NULL input. Invalid percent encoding or invalid decoded UTF-8 also returns NULL.

​

Properties

​

Usage notes

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

​

Examples

​

Typical behavior

SELECT try_url_decode('a+b%2Bc') AS "value", try_url_decode('bad%2s') AS invalid;

​

Decode UTF-8 text

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