Correct, both of those sorts are what I would call natural (or alphanumeric ) sorts and exactly what I am trying get.
On Apr 2, 2014, at 8:13 AM, Richard Hipp <[email protected]> wrote: > On Wed, Apr 2, 2014 at 11:09 AM, James Berry <[email protected]> wrote: > >> One thing you might want to review is whether the results of the natural >> sort algorithm here: http://sourcefrog.net/projects/natsort/ would be >> what you want. If so, you should be able to incorporate that algorithm, or >> a variant in a convenient language, as part of your collation. >> >> > > The -dictionary option to the "lsort" command of Tcl is similar: > http://www.tcl.tk/man/tcl8.6/TclCmd/lsort.htm > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
