Normal
Thanks ojo,That's exactly what I thought too and your solution definitely works fine!In the meantime I've found out that in-memory sorting works cool in my case, so I will stick to that.... if it gets too slow I will do a database-SQL sort!The other problem with SQLite sorting is that SQLite simply does an strict ASCII sort (so items beginning with lowercase 'a' appear after items with uppercase 'Z', like this: "ABBA", "YES", "ZAPPA", "abba2"... )Anybody has an idea of how to influence the SQLite sort order?Workaround would be to have an uppercase version of the sort field stored in the table (to make sure the index can be used).This seems too complicated to me.... so I'll stick to in-memory sorting for now!Thanks again,Daniel
Thanks ojo,
That's exactly what I thought too and your solution definitely works fine!
In the meantime I've found out that in-memory sorting works cool in my case, so I will stick to that.... if it gets too slow I will do a database-SQL sort!
The other problem with SQLite sorting is that SQLite simply does an strict ASCII sort (so items beginning with lowercase 'a' appear after items with uppercase 'Z', like this: "ABBA", "YES", "ZAPPA", "abba2"... )
Anybody has an idea of how to influence the SQLite sort order?
Workaround would be to have an uppercase version of the sort field stored in the table (to make sure the index can be used).
This seems too complicated to me.... so I'll stick to in-memory sorting for now!
Thanks again,
Daniel