1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
3 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
5 SELECT * FROM t1 ORDER BY c1;
8 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
9 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
11 SELECT * FROM t1 ORDER BY c1;
14 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
15 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
17 SELECT * FROM t1 ORDER BY c1;
20 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
21 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
23 SELECT * FROM t1 ORDER BY c1;
26 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
27 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
29 SELECT * FROM t1 ORDER BY c1;
32 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
33 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
35 SELECT * FROM t1 ORDER BY c1;
38 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
39 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
41 SELECT * FROM t1 ORDER BY c1;
44 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
45 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
47 SELECT * FROM t1 ORDER BY c1;