--disable_warnings DROP TABLE IF EXISTS t1, t2; --enable_warnings CREATE TABLE t1 (f1 BIGINT, f2 BINARY(2) NOT NULL); CREATE TABLE t2 (f1 BIGINT, f2 VARBINARY(2) NOT NULL); SHOW CREATE TABLE t1; SHOW CREATE TABLE t2; INSERT INTO t1 SET f1 = 1; INSERT INTO t1 SET f1 = 2, f2 = CAST('a' AS BINARY(1)); INSERT INTO t2 SET f1 = 1; INSERT INTO t2 SET f1 = 2, f2 = CAST('a' AS BINARY(1)); # the next statement gives a wrong result for the first record (f1 = 1) SELECT f1, f2, HEX(f2) FROM t1; SELECT f1, f2, HEX(f2) FROM t2;