MySQL Forums
Forum List  »  Full-Text Search

Full-text search supports Accent insensitive matches?
Posted by: Francisco Caserio
Date: August 27, 2009 02:10PM

The word "criança" is registered on the indexed field on several records of my table.

The following statements returns this records:
field LIKE _utf8'%crianca%'COLLATE utf8_unicode_ci
MATCH(field) AGAINST (_utf8'criança'COLLATE utf8_unicode_ci IN BOOLEAN MODE)

But when using match with the unaccented word I get no results
MATCH(field) AGAINST (_utf8'crianca'COLLATE utf8_unicode_ci IN BOOLEAN MODE)

Does Full-text search supports Accent insensitive matches?

tks for any help

Options: ReplyQuote


Subject
Views
Written By
Posted
Full-text search supports Accent insensitive matches?
5306
August 27, 2009 02:10PM


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.