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 |