DROP TABLE IF EXISTS t1; CREATE TABLE t1 (c1 CHAR(10) CHARSET utf8); INSERT INTO t1 VALUES ("foo bar"), ("foo, bar"), ("foo-bar"); SELECT * FROM t1 ORDER BY c1 COLLATE utf8_bin; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_general_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_unicode_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_czech_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_danish_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_esperanto_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_estonian_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_hungarian_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_icelandic_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_latvian_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_lithuanian_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_persian_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_polish_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_roman_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_romanian_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_slovak_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_slovenian_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_spanish_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_spanish2_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_swedish_ci; SELECT * FROM t1 ORDER BY c1 COLLATE utf8_turkish_ci;