By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE tABLE ab(te char(2))
INSERT INTO ab VALUES('ð')
SELECT HEX(te), HEX ('d') FROM ab WHERE BINARY(te) = BINARY('d')
CREATE TABLE t1 (c CHAR(10) COLLATE utf8mb4_bin);
INSERT INTO t1 VALUES('ð')
SELECT * FROM t1 WHERE c = 'd'