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 http://www.sqlite.org/capi3ref.html#sqlite3_create_collation > http://www.mail-archive.com/sqlite-users%40sqlite.org/ > http://site.icu-project.org/ I'd like to also mention http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/icu/README.txt Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 http://www.sqlite.org/capi3ref.html#sqlite3_create_collation http://www.mail-archive.com/sqlite-users%40sqlite.org/ http://site.icu-project.org/ Martin MartinRalf schrieb: > 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? > > > > Cheers > > Ralf > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Problem with -order by- clause
Hello, Ive 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? Cheers Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users