bitmap_to_base64

description

Syntax

VARCHAR BITMAP_TO_BASE64(BITMAP input)

Convert an input BITMAP to a base64 string. If input is null, return null. Since BE config item enable_set_in_bitmap_value will change the format of bitmap value in memory, it also affect the result of this function.

example

1. mysql> select bitmap_to_base64(null);
2. +------------------------+
3. | bitmap_to_base64(NULL) |
4. +------------------------+
5. | NULL                   |
6. +------------------------+

8. mysql> select bitmap_to_base64(bitmap_empty());
9. +----------------------------------+
10. | bitmap_to_base64(bitmap_empty()) |
11. +----------------------------------+
12. | AA==                             |
13. +----------------------------------+

15. mysql> select bitmap_to_base64(to_bitmap(1));
16. +--------------------------------+
17. | bitmap_to_base64(to_bitmap(1)) |
18. +--------------------------------+
19. | AQEAAAA=                       |
20. +--------------------------------+

22. mysql> select bitmap_to_base64(bitmap_from_string("1,9999999"));
23. +---------------------------------------------------------+
24. | bitmap_to_base64(bitmap_from_string("1,9999999"))       |
25. +---------------------------------------------------------+
26. | AjowAAACAAAAAAAAAJgAAAAYAAAAGgAAAAEAf5Y=                |
27. +---------------------------------------------------------+

keywords

1. BITMAP_TO_BASE64,BITMAP