Skip to main content
Version: Latest-3.3

base64_decode_binary

Description

Decodes a Base64-encoded string and return a BINARY.

This function is supported from v3.0.

Syntax

base64_decode_binary(str);

Parameters

str: the string to decode. It must be of the VARCHAR type.

Return value

Returns a value of the VARBINARY type. If the input is NULL or an invalid Base64 string, NULL is returned. If the input is empty, an error is returned.

This function accepts only one string. More than one input string causes an error.

Examples

mysql> select hex(base64_decode_binary(to_base64("Hello StarRocks")));
+---------------------------------------------------------+
| hex(base64_decode_binary(to_base64('Hello StarRocks'))) |
+---------------------------------------------------------+
| 48656C6C6F2053746172526F636B73 |
+---------------------------------------------------------+

mysql> select base64_decode_binary(NULL);
+--------------------------------------------------------+
| base64_decode_binary(NULL) |
+--------------------------------------------------------+
| NULL |
+--------------------------------------------------------+