bitmap_from_base64

description

Syntax

BITMAP BITMAP_FROM_BASE64(VARCHAR input)

Convert a base64 string(result of function bitmap_to_base64) into a bitmap. If input string is invalid, return NULL.

example

  1. mysql> select bitmap_to_string(bitmap_from_base64("AA=="));
  2. +----------------------------------------------+
  3. | bitmap_to_string(bitmap_from_base64("AA==")) |
  4. +----------------------------------------------+
  5. |                                              |
  6. +----------------------------------------------+
  8. mysql> select bitmap_to_string(bitmap_from_base64("AQEAAAA="));
  9. +-----------------------------------+
  10. | bitmap_to_string(bitmap_from_base64("AQEAAAA=")) |
  11. +-----------------------------------+
  12. | 1                                 |
  13. +-----------------------------------+
  15. mysql> select bitmap_to_string(bitmap_from_base64("AjowAAACAAAAAAAAAJgAAAAYAAAAGgAAAAEAf5Y="));
  16. +----------------------------------------------------------------------------------+
  17. | bitmap_to_string(bitmap_from_base64("AjowAAACAAAAAAAAAJgAAAAYAAAAGgAAAAEAf5Y=")) |
  18. +----------------------------------------------------------------------------------+
  19. | 1,9999999                                                                        |
  20. +----------------------------------------------------------------------------------+

keywords

  1. BITMAP_FROM_BASE64,BITMAP