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