In MariaDB, BIN()
is a built in string function that returns a string representation of the binary value of the given longlong (i.e. BIGINT
) number.
You provide the longlong number when you call the function.
Syntax
The syntax goes like this:
BIN(N)
Where N
is the longlong number.
Example
Here’s a simple example:
SELECT BIN(123);
Result:
+----------+ | BIN(123) | +----------+ | 1111011 | +----------+
This is the same as CONV(123, 10, 2)
. Here it is alongside that function:
SELECT
BIN(123),
CONV(123,10,2);
Result:
+----------+----------------+ | BIN(123) | CONV(123,10,2) | +----------+----------------+ | 1111011 | 1111011 | +----------+----------------+
Using a float
Value
If the argument is a float
, it’s truncated.
Example:
SELECT BIN(123.456);
Result:
+--------------+ | BIN(123.456) | +--------------+ | 1111011 | +--------------+
Wrong Argument Type
Passing the wrong argument type returns 0
.
Example:
SELECT BIN('Homer');
Result:
+--------------+ | BIN('Homer') | +--------------+ | 0 | +--------------+
Null Arguments
Passing null
returns null
:
SELECT BIN(null);
Result:
+-----------+ | BIN(null) | +-----------+ | NULL | +-----------+
Missing Argument
Calling BIN()
without passing an argument results in an error:
SELECT BIN();
Result:
ERROR 1582 (42000): Incorrect parameter count in the call to native function 'BIN'