On Jul 30, 2004, at 1:49 PM, tezozomoc wrote:
HOWTO: Adding Natural Sort To Sqlite Database...
Assumption... this is based on SQLITE 2.8.6... forgive the aging..
I will make this very short and sweet...
1. Get the following two files:
a.. strnatcmp.c, strnatcmp.h - the algorithm itself from a.. http://sourcefrog.net/projects/natsort/
add to your sqlite build project, I am using VxWorks, so the way that I did it will probably will not make sense...
2. Open util.c
3. Replace the following: ............
This sounds great. can you give an SQL Statement example and explain what was wrong with sqliteSortCompare?
Thanks.