FROM_BASE64()

FROM_BASE64() is used to convert a Base64 encoded string back to raw binary data (or text data).

Function Description

FROM_BASE64() is used to convert a Base64 encoded string back to raw binary data (or text data). Data that is Base64 encoded using the TO_BASE64() function can be decoded. If the argument is NULL, the result is NULL.

Function syntax

> FROM_BASE64(str)

Parameter interpretation

Parameters	Description
str	Required parameters. Base64 encoded string to convert.

Examples

mysql> select from_base64('MjU1');
+-------------------+
| from_base64(MjU1) |
+-------------------+
| 255               |
+-------------------+
1 row in set (0.00 sec)

mysql> SELECT TO_BASE64('abc'), FROM_BASE64(TO_BASE64('abc'));
+----------------+-----------------------------+
| to_base64(abc) | from_base64(to_base64(abc)) |
+----------------+-----------------------------+
| YWJj           | abc                         |
+----------------+-----------------------------+
1 row in set (0.00 sec)

mysql> select from_base64(null);
+-------------------+
| from_base64(null) |
+-------------------+
| NULL              |
+-------------------+
1 row in set (0.01 sec)

Known Issues

Decoded output from FROM_BASE64() may include trailing null bytes (\0) that are not present in the original input. For example, FROM_BASE64('YQ==') returns 'a\0\0' (length 3) instead of 'a' (length 1). MySQL strips these bytes automatically; MatrixOne currently retains them.