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) |