Skip to main content

BITMAP_FROM_BASE64

Description​

Convert a base64 string (which can be converted by bitmap_to_base64 function) to a BITMAP. Returns NULL when the input string is invalid.

Syntax​

 BITMAP_FROM_BASE64(<base64_str>)

Parameters​

ParameterDescription
<base64_str>base64 string (can be converted by bitmap_to_base64 function)

Return Value​

Returns a BITMAP

  • When the input field is invalid, the result is NULL

Examples​

select bitmap_to_string(bitmap_from_base64("AA==")) bts;
+------+
| bts |
+------+
| |
+------+
select bitmap_to_string(bitmap_from_base64("AQEAAAA=")) bts;
+------+
| bts |
+------+
| 1 |
+------+
select bitmap_to_string(bitmap_from_base64("AjowAAACAAAAAAAAAJgAAAAYAAAAGgAAAAEAf5Y=")) bts;
+-----------+
| bts |
+-----------+
| 1,9999999 |
+-----------+