Re: Problem with fulltext search using encoded german umlauts (strange behaviour of "MATCH(column) AGAINST ('keyword' IN BOOLEAN MODE)")

[Web Team]

Hi Rick,

thanx for your help, unfortunately we need to have the HTML entities in the database, because of using some special WYSIWYG-editor and having some encoding problems on that platform.

We already set the ft_min_word_len to 3 because of some german words ;-)
We haven't replaced the stoplist as far as i know, do you know any good translated stoplist sources?

Greetings
Toby

BTW: I am discussing this problem in german in the german section of this forum...
http://forums.mysql.com/read.php?70,364107,364107#msg-364107

Thanx to Markus we found out, that the ampersand is a special operator for fulltext searches (ft_boolean_syntax). Although it is just a reserved parameter for future implementations, it is already locked now. So we changed the default setting of operators from

+ -><()~*:""&|

to

+ -><()~*:""#|

but without any success for now...



Edited 2 time(s). Last edit at 04/22/2010 02:22AM by Web Team.