MySQL Forums
Forum List  »  Full-Text Search

Fulltext and Unicode
Posted by: Penko Mitev
Date: March 22, 2008 03:18PM

Good evening,
I would like to ask why I can't make FULLTEXT work with utf8_unicode_ci? The site I am making is based on Bulgarian languages, which uses the cyrillic alphabet and I am obligated to use utf8_unicode_ci because there is an option for english and german too. Could you tell me what I should do in order to make FULLTEXT work. For instance,
If I search for "book" and I have a record consisting of "book", MySQL returns the result, while if I perform a search for "книга"("book" in Bulgarian) and I have a record also containing "книга", MySQL returns empty result.

I would like to hear also alternatives to FULLTEXT search if such exist.

Thank you in advance for the help.

Options: ReplyQuote

Written By
Fulltext and Unicode
March 22, 2008 03:18PM

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.