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