bitmap_from_base64

description

Syntax

BITMAP BITMAP_FROM_BASE64(VARCHAR input)

将一个base64字符串(bitmap_to_base64函数的结果)转化为一个BITMAP。当输入字符串不合法时，返回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