Quote [Jeff Smith]:
Keep in mind that although MATCH() AGAINST() is case-insensitive, it also is basically **accent-insensitive**. In other words, if you do not want _mang韠to match with _mange_ (this example is in French), you have no choice but to use the BOOLEAN MODE with the double quote operator. This is the only way that MATCH() AGAINST() will make accent-sensitive matches.
E.g.:
SELECT * FROM quotes_table WHERE MATCH (quote) AGAINST ('"mang馱uot;' IN BOOLEAN MODE)
For multiword searches:
SELECT * FROM quotes_table MATCH (quote) AGAINST ('"mang馱uot; "pens馱uot;' IN BOOLEAN MODE)
SELECT * FROM quotes_table MATCH (quote) AGAINST ('+"mang馱uot; +"pens馱uot;' IN BOOLEAN MODE)
Although the double quotes are intended to enable phrase searching, just like any web search engine for example, you can also use them to signify single words where accents and other diacritics matter.
The only drawback to this method seems to be that the asterisk operator is mutually exclusive with the double quote. Or I just haven't been able to combine both effectively.
Taken from
http://dev.mysql.com/doc/mysql/en/fulltext-boolean.html Second comment.
Regards,
Martyn Coupland
Development Officer