bitmap_to_base64

description

Syntax

VARCHAR BITMAP_TO_BASE64(BITMAP input)

将一个bitmap转化成一个base64字符串。输入是null的话返回null。BE配置项enable_set_in_bitmap_value会改变bitmap值在内存中的具体格式，因此会影响此函数的结果。

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