MySQL Forums
Forum List  »  Full-Text Search

SEarching Hebrew string, What collation should I use
Posted by: Itay Moav
Date: August 31, 2009 08:03AM

Greetings,

I am using full text to search in Hebrew columns. I noticed when I use
encoding: utf9
collation: utf8_general_ci

That the search misses things, for example the words:
מוסינזון
מושינזון
should be regarded as the same, but searching for the one, won't find the rows where the other one exists (the difference is the letters ס to ש)
Is there a built in solution in mysql for that?
What collation should I use?

Do you need a Q/A site for FREE! Check my open source project http://phpancake.sourceforge.net
Watch movies at http://rainofmovies.awardspace.info

Options: ReplyQuote


Subject
Views
Written By
Posted
SEarching Hebrew string, What collation should I use
4144
August 31, 2009 08:03AM


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.