mysql-test/suite/maria/collations.test
raw| 1 | # |
| 2 | # Test 2-byte collations |
| 3 | # |
| 4 | |
| 5 | DROP TABLE IF EXISTS t1; |
| 6 | |
| 7 | CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_croatian_ci, KEY(a)) ENGINE=ARIA; |
| 8 | INSERT INTO t1 VALUES ('na'),('nj'),('nz'),('Z'); |
| 9 | explain SELECT a FROM t1 ORDER BY a; |
| 10 | SELECT a FROM t1 ORDER BY a; |
| 11 | ALTER TABLE t1 engine=myisam; |
| 12 | explain SELECT a FROM t1 ORDER BY a; |
| 13 | SELECT a FROM t1 ORDER BY a; |
| 14 | drop table t1; |