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


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
Watch movies at

Options: ReplyQuote

Written By
SEarching Hebrew string, What collation should I use
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.