MySQL Forums
Forum List  »  Full-Text Search

Re: Problem with fulltext search using encoded german umlauts (strange behaviour of "MATCH(column) AGAINST ('keyword' IN BOOLEAN MODE)")
Posted by: Web Team
Date: April 22, 2010 02:13AM

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?


BTW: I am discussing this problem in german in the german section of this forum...,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

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


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

but without any success for now...

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

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.