Re: [sqlite] Problem with -order by- clause

Martin.Engelschalk wrote: > The sorting used by default in sqlite uses normal strcmp - like > comparison. > > This problem has been discussed several times in the mailing list: > perhaps you want to search the archive. > You will have to write your own collation, perhaps using the ICU. > See

Re: [sqlite] Problem with -order by- clause

Hi, The sorting used by default in sqlite uses normal strcmp - like comparison. This problem has been discussed several times in the mailing list: perhaps you want to search the archive. You will have to write your own collation, perhaps using the ICU. See

[sqlite] Problem with -order by- clause

Hello, I’ve got a problem with sorting german ‚Umlaute’ eg. ’äöü’ (ae,oe,ue) Usually they are sorted prior to the corresponding Letter: ü before u In SqLite with ‘Collate Locale’ these letters are sorted at the end after ‘z’ Is there a solution or do I have to ‘live’ with it?