Lines Matching refs:text
219 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE text}
228 cksort {SELECT a FROM collate4t1 ORDER BY a, b COLLATE text}
250 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE text}
259 cksort {SELECT a FROM collate4t2 ORDER BY a, b COLLATE text}
280 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text}
283 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b}
286 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b COLLATE nocase}
289 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b COLLATE text}
292 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text DESC}
295 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text DESC, b}
299 ORDER BY a COLLATE text DESC, b COLLATE nocase}
303 ORDER BY a COLLATE text DESC, b COLLATE nocase DESC}
417 CREATE TABLE collate4t1(a COLLATE nocase, b COLLATE text, c);
418 CREATE TABLE collate4t2(a COLLATE nocase, b COLLATE text, c COLLATE TEXT);
447 CREATE INDEX collate4i1 ON collate4t1(a, b, c COLLATE text);