SET NAMES latin1;

CREATE TABLE t1 (a CHAR(10) PRIMARY KEY, b CHAR(10) NOT NULL, KEY(b)) CHARSET latin1 ENGINE=InnoDB;
CREATE TABLE t2 (a CHAR(10) PRIMARY KEY, b TINYTEXT NOT NULL, KEY(b(10))) CHARSET latin1 ENGINE=InnoDB;
INSERT INTO t1 VALUES ("hello ","hello "),("hello2 ","hello2 ");
INSERT INTO t2 VALUES ("hello ","hello "),("hello2 ","hello2 ");
SELECT CONCAT("-",a,"-",b,"-") FROM t1 WHERE b="hello ";
SELECT CONCAT("-",a,"-",b,"-") FROM t2 WHERE b="hello ";
SELECT CONCAT("-",a,"-",b,"-") FROM t1 WHERE b LIKE "hello ";
SELECT CONCAT("-",a,"-",b,"-") FROM t2 WHERE b LIKE "hello ";
SELECT CONCAT("-",a,"-",b,"-") FROM t1 WHERE b LIKE "hello %";
SELECT CONCAT("-",a,"-",b,"-") FROM t2 WHERE b LIKE "hello %";

DROP TABLE t1, t2;
SET NAMES default;