SQLite Forum

Natural sort order
Login
Richard having natural sorting of this kind available as a standard collation in SQLite would be useful.

Actually I am working on a bespoke collation that handles number naturally like this, is case insensitive and does some simple accent folding so 'a', 'á' and 'À' are with 'A'. However the result is slower than I would like, and I think that is partly because of the way I am converting from the `const void` data of the collation callback function into `wstring` before processing compare even though most of the data is simple ascii.Need to give that more thought.