MySQL Forums
Forum List  »  Full-Text Search

Problem with searching of special character
Posted by: cong tran
Date: May 13, 2008 03:44AM


I have a table person_info, which contain a column 'person_name'. My table was defined in utf8_general_ci. Many 'person_name'contain name with special character like á, à, or Ã.
Now I want to get only the name with special character. For example:

-> get only the name ángelo.
I used this query : select person_name from person_info where person_name like '%á%';
But I got than the both name 'ángelo' and 'angelo'. Mysql may be don't differ between 'a' and 'á'.

Have somebody an idea, how I can resolve this problem?

Thanks you very much.

Options: ReplyQuote

Written By
Problem with searching of special character
May 13, 2008 03:44AM

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.