Re: [sqlite] Sort order with umlauts
"Lukas Haase" wrote in message news:gt0078$n7...@ger.gmane.org > Now I have the problem that I have also words with umlauts. Now they > are sorted this way: > > But I need the umlauts treated as their respective vovels, i.e.: http://sqlite.org/c3ref/create_collation.html Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sort order with umlauts
-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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sort order with umlauts
Hello, For a database I also need a fulltext index. This is my table containing all the words: CREATE TABLE db_fulltext.fulltext( fulltextID INTEGER PRIMARY KEY, word VARCHAR(100) COLLATE NOCASE ); Now I have the problem that I have also words with umlauts. Now they are sorted this way: ua .. uz .. zz .. üa .. But I need the umlauts treated as their respective vovels, i.e.: ua üa .. uz .. zz Is this somehow possible? Greets, Luke ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
