Lines Matching refs:HEX
31 # Collation type 'HEX'. If an argument can be interpreted as a hexadecimal
36 db collate HEX hex_collate
55 db function hex {format 0x%X}
67 INSERT INTO collate1t1 VALUES(45, hex(45));
69 INSERT INTO collate1t1 VALUES(281, hex(281));
79 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex;
84 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex DESC;
89 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex ASC;
94 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1
99 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1 ASC
104 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1 DESC
126 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE numeric, 2 COLLATE hex;
131 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE binary, 2 COLLATE hex;
136 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE binary DESC, 2 COLLATE hex;
142 ORDER BY 1 COLLATE binary DESC, 2 COLLATE hex DESC;
148 ORDER BY 1 COLLATE binary ASC, 2 COLLATE hex ASC;
154 ORDER BY 1, 2 COLLATE hex;
159 SELECT c1 COLLATE hex, c2 FROM collate1t1
160 ORDER BY 1 COLLATE numeric, 2 COLLATE hex;
165 SELECT c1, c2 COLLATE hex FROM collate1t1
171 SELECT c1 COLLATE numeric, c2 COLLATE hex
178 SELECT c1 COLLATE binary, c2 COLLATE hex
186 FROM collate1t1 ORDER BY 1 COLLATE binary DESC, 2 COLLATE hex;
191 SELECT c1 COLLATE binary, c2 COLLATE hex
198 SELECT c1 COLLATE hex, c2 COLLATE binary
200 ORDER BY 1 COLLATE binary ASC, 2 COLLATE hex ASC;
216 CREATE TABLE collate1t1(a COLLATE hex, b);
