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
Parameter | Description |
---|---|
<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 |
+-----------+