Max Vlasov wrote: > 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"? > > 1, 2, 10, something > that's what I wanted
So you actually want to sort strings as if they were numbers (if possible)? In this case, you need NUMBER affinity. For SQLite's sort order, see <http://www.sqlite.org/datatype3.html#comparisons>. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
