How to query BIT data type from Mysql / MariaDB

Question and Answers
1

How to query BIT data type from Mysql / MariaDB ?

2

Please try to query it like this select BIN(days) from my_calendars; ie. wrap your BIT data type column in BIN.
Reference: select - Mysql: How to query a column whose type is bit? - Stack Overflow

3

The data returned by default e.g AA== is base64 encoded. Hence, alternatively you could also choose to decode base64 on the client side using Javascript.