Hi, I'm using sqlite 3.0.8 and testing collation sequences and have have some doubts on the following behaviour:
SQLite version 3.0.8 Enter ".help" for instructions sqlite> create table t(a); sqlite> insert into t values (100); sqlite> insert into t values (11); sqlite> select * from t order by a collate binary; 11 100 sqlite> select * from t order by a; 11 100 sqlite> select * from t order by a collate binary desc; 100 11 sqlite> drop table t; sqlite> create table t(a text); sqlite> insert into t values (100); sqlite> insert into t values (11); sqlite> select * from t order by a collate binary; 100 11 sqlite> select * from t order by a collate binary desc; 11 100 The collation sequence "binary" was not being used when i declared the column a without a type, but when i included the *text* type the collation sequence was used to sort the result. Is this the expected behaviour? Tiago
