Skip to main content

1E 8.1 (on-premises)

BASE64DECODE

Function

BASE64DECODE

Action

Produces a decoded Base64/Base64Url string.

Parameters

(string) Input Base64/Base64Url text to be decoded.

Return values

(string) Decoded Base64/Base64Url string.

Example

// Returns "ABCabc123!@#=|>z<?"
SELECT BASE64DECODE("QUJDYWJjMTIzIUAjPXw+ejw/") AS Base64Decoded;
// Returns "ABCabc123!@#=|>z<?"
SELECT BASE64DECODE("QUJDYWJjMTIzIUAjPXw-ejw_") AS Base64UrlDecoded;

Notes

Introduced in v23.5

From v24.9 onwards, this function also decodes a Base64UrlEncoded string