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

[Rick James]

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.