On Apr 2, 2014, at 7:36 AM, James Berry <ja...@jberry.us> wrote: > On Apr 2, 2014, at 7:28 AM, Donald Steele <xln...@sbcglobal.net> wrote: > >> I read some where in my searches that Apple has “canned” versions of that >> method but I can’t find those either. >> >> Could someone direct me to some basic tutorials or explanations where I can >> get a better understanding before I dive in to create my own collation? > > Can you give us some examples of the data that’s not sorting properly? > > Is the issue that mixed alpha and numeric fields don’t sort as you expect > (for instance, that “I-5” sorts after “I-400”?)
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. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
