MySQL Forums
Forum List  »  Full-Text Search

searching UTF-8 encoded text
Posted by: antony castle
Date: February 22, 2010 10:24AM

Hi, I'm trying to add a search search facility to a table containing data stored as UTF-8 encoded text. I need to be able to search the data in a way such that "foreign characters" are considered as their latin1 equivalents.

For example the string "řýchle" should be considered the same as the string "rychle". This is possible in php using the php function iconv() with the transliteration flag set.

Is there a similar function that can be used in mysql queries?

Any help with this would be very gratefully received!

Many thanks.

Options: ReplyQuote

Written By
searching UTF-8 encoded text
February 22, 2010 10:24AM

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.