-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Lukas Haase wrote: > Now I have the problem that I have also words with umlauts.
To get correct sorting and case conversion then the best method is to use the ICU SQLite extension. You can read about it at http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/icu/README.txt If you don't care too much about correctness, locales etc then search the archives of this mailing list where various people have posted approaches that are smaller/faster than ICU at the expense of accuracy and coverage. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkn0B2QACgkQmOOfHg372QSdnACg5UL6GSZfDQ5rm2htvlvS5BID CxcAn39S75/PpKRYX9fB4YQtxxZsVPN4 =nfC5 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
