MySQL when a = 0, b = 0, but a  b (binary)
BINARY is a misnomer.  It really refers to a string of bytes; it does not refer to binary numbers, and it isn't a unique datatype.

Also, = and &lt;&gt; adapt to the datatype(s) involved:

SELECT a=0, b=0,    -- numeric comparisons
       a=b, a&lt;&gt;b    -- BLOB comparisons; length matters
    FROM f;


It is a combination of the Operator and the Datatypes that controls what string vs numeric operations.

Some info on datatypes:

BINARY / VARBINARY / BLOB can be manipulated with "bit" operators | &amp; ~ ^ -- not to be confused with logical operators AND (&amp;&amp;) and OR (||).  BLOB-like columns are used for non-character strings, such as images.  MySQL 8.0 stretches these operators beyond a 64-bit limit.  INT can also be manipulated with bit operators.

The BIT(m) datatype is prefixed with leading zeros if needed to fill out to full byte(s).  (Limit 64 bits.)  This datatype is almost never used.

BINARY(1) and BINARY(22) are 1- and 22-byte datatypes.  CAST(1 AS BINARY(1) converts the first 1 to a string "1", then stuffs in hex 31 (ascii code for "1").  Try SELECT HEX(CAST(1 AS binary(1))), HEX(CAST("1" AS BINARY(1))); -- both yield 31.