Debian Codegraph @

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;