DROP TABLE IF EXISTS t1; CREATE TABLE t1 (c1 CHAR(10) CHARSET latin1); INSERT INTO t1 VALUES ("foo bar"), ("foo, bar"), ("foo-bar"); SELECT * FROM t1 ORDER BY c1 COLLATE latin1_bin; SELECT * FROM t1 ORDER BY c1 COLLATE latin1_general_ci; SELECT * FROM t1 ORDER BY c1 COLLATE latin1_general_cs; SELECT * FROM t1 ORDER BY c1 COLLATE latin1_danish_ci; SELECT * FROM t1 ORDER BY c1 COLLATE latin1_german1_ci; SELECT * FROM t1 ORDER BY c1 COLLATE latin1_german2_ci; SELECT * FROM t1 ORDER BY c1 COLLATE latin1_spanish_ci; SELECT * FROM t1 ORDER BY c1 COLLATE latin1_swedish_ci;