Skip to main content

FROM_BASE64

Takes a string encoded with the base-64 encoded rules nd returns the decoded result as a binary string. The result is NULL if the argument is NULL or not a valid base-64 string.

Syntax​

FROM_BASE64(s)

Arguments​

ArgumentsDescription
sThe string value.

Return Type​

A String data type value.

Examples​

SELECT TO_BASE64('abc'), FROM_BASE64(TO_BASE64('abc'));
+------------------+-------------------------------+
| TO_BASE64('abc') | FROM_BASE64(TO_BASE64('abc')) |
+------------------+-------------------------------+
| YWJj             | abc                           |
+------------------+-------------------------------+