1SELECT @@collation_connection; 2--echo # 3--echo # Bug#57737 Character sets: search fails with like, contraction, index 4--echo # 5CREATE TABLE t1 AS SELECT REPEAT(' ', 10) AS s1 LIMIT 0; 6INSERT INTO t1 VALUES ('c'),('ce'),('cé'),('ch'); 7SELECT * FROM t1 WHERE s1 LIKE 'c%'; 8ALTER TABLE t1 ADD KEY s1 (s1); 9SELECT * FROM t1 WHERE s1 LIKE 'c%'; 10ALTER TABLE t1 DROP KEY s1, ADD KEY(s1(1)); 11SELECT * FROM t1 WHERE s1 LIKE 'ch'; 12DROP TABLE t1; 13