RE: [sqlite] How to sort not binary?

2007-06-25 Thread Samuel R. Neff
e.org Subject: [sqlite] How to sort not binary? Hi, I'm trying to get my table sorted the way how for example Windows Explorer or other file managers are sorting names. Most of all, accented characters should not be listed at the end of the list but near their non-accented character instead. I ca

Re: [sqlite] How to sort not binary?

2007-06-25 Thread Yves Goergen
On 25.06.2007 00:57 CE(S)T, [EMAIL PROTECTED] wrote: > Yves Goergen <[EMAIL PROTECTED]> wrote: >> Oh, well, I just realised that this will only sort numbers "naturally" >> at the beginning of strings, but not in the middle or at the end. It >> will be a bit more complex to do that. Maybe I find a s

Re: [sqlite] How to sort not binary?

2007-06-24 Thread drh
Yves Goergen <[EMAIL PROTECTED]> wrote: > On 22.06.2007 17:48 CE(S)T, Yves Goergen wrote: > > Match m1 = Regex.Match(param1, "^([0-9]+)"); > > if (m1.Success) > > { > > Match m2 = Regex.Match(param2, "^([0-9]+)"); > > if (m2.Success) > > { > > int cmpNum = int.

[sqlite] How to sort not binary?

2007-05-12 Thread Yves Goergen
Hi, I'm trying to get my table sorted the way how for example Windows Explorer or other file managers are sorting names. Most of all, accented characters should not be listed at the end of the list but near their non-accented character instead. I can only see the built-in collations BINARY and NOC