BIN()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Returns a string representation of the binary value of the given BIGINT number.
EXAMPLES
CREATE TABLE bin_example (
example BIGINT
);
INSERT INTO bin_example VALUES
(42), (101), (99), (13), (64), (86);
SELECT BIN(example) FROM bin_example;
+--------------+
| BIN(example) |
+--------------+
| 101010 |
| 1100101 |
| 1100011 |
| 1101 |
| 1000000 |
| 1010110 |
+--------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.