On Tue, Jul 23, 2013 at 1:32 PM, Clemens Ladisch <clem...@ladisch.de> wrote:
> > > But REAL will sort the strings '1', '10', '2' wrong. > What do you mean by "wrong"? The test CREATE TABLE testtable (id integer primary key, value real); insert into testtable (value) values ('1'); insert into testtable (value) values ('2'); insert into testtable (value) values ('10'); insert into testtable (value) values ('something'); CREATE INDEX [idx_Testable] ON [testtable] ([Value]); SELECT * FROM testtable order by value; will show 1, 2, 10, something that's what I wanted (except for "something" being exception) if I change create to CREATE TABLE testtable (id integer primary key, value); then the order will be 1, 10, 2, something. (undesired result) Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users