Going back to my origanal question, it was perhaps not stated correctly.
The creation of a collation looks to be a two part process.
1) The defining the actual compare process.
2) The declaring of the custom collation.
The first part is where my confusion is. First of course is where it takes
place but then since I would apply it to a column of a table as part of a
select statement what are the strings in the compare and how do I set a length
when the length will vary?
On Apr 2, 2014, at 8:57 AM, Donald Steele <[email protected]> wrote:
> 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
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
