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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to