Binary string operands
Binary strings are compatible with other binary strings. Binary strings include BINARY, VARBINARY, and BLOB.
One operand | Other operand | Data type of the result |
---|---|---|
BINARY(x) | BINARY(y) | BINARY(z) where z = max(x,y) |
VARBINARY(x) | BINARY(y) or VARBINARY(y) | VARBINARY(z) where z = max(x,y) |
BLOB(x) | BINARY(y), VARBINARY(y), or BLOB(y) | BLOB(z) where z = max(x,y) |