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: Rick James
Date: April 21, 2010 09:04PM

I would argue that it is wrong to have "HTML entities" (eg, "ä") in the database.

Could you use a few calls to REPLACE() to change 'Köln' into 'Koumlln';
Or several to change it to 'Köln'?

Other issues:

Have you changed the "stoplist" -- the default list of words is aimed at English.

'Ulm' will be a problem unless you change ft_min_word_len to less than the default of 4.

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.