MySQL Forums
Forum List  »  Full-Text Search

"Examples of the Effect of Collation" solution?
Posted by: Christoffer Pettersson
Date: October 23, 2007 03:20AM

Hi everyone!

We have an annoying problem as described in the article "Examples of the Effect of Collation" (http://dev.mysql.com/doc/refman/5.0/en/charset-collation-effect.html).

We are using UTF8 encoded tables (CHARACTER SET utf8 COLLATE utf8_unicode_ci;) where we planned on having texts in different languages (english, swedish, german, etc) stored.

Our problem is (as noted in the article) is that our search is broken; our Swedish "ä" becomes "ä" and "a". So searching for "bär" will return both "bar" and "bär". Same problem with other languages.

However, we don't have a solution to this. Is there any? What alternatives can we make, in order that our searches will work? We are also using PHP, if you know any solution they might have as well.

Any advice or comment would be much appreciated! :)

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
"Examples of the Effect of Collation" solution?
3971
October 23, 2007 03:20AM


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.