preg_rlike not matching characters like ò , í , è etc

Question

Can you hep me to match special characters like ò , í , è with mysql preg_rlike

select first_name from authors where preg_rlike('/Jòse/i',authors.first_name);

It will not retrieve data even if the database has value.

We can handle this with LIKE but I have many like Jòse|Jose|James

Let me please know how can we handle this.

Are you saying that you _don't_ want to treat accented vowels different than none accented vowels, or are you asking something else? — Tim Biegeleisen, Aug 07 '17 at 06:09
Is field `first_name` has Collation: `utf8_general_ci`, then can you try `select first_name from authors where like '%Jòse%';` — Sinto, Aug 07 '17 at 07:07
@tim-biegeleisen the query in my description is not retrieving data, even if the table has values with first_name as Jòse — Ha Dev, Aug 07 '17 at 08:06

score 0 · Accepted Answer · answered Aug 17 '17 at 06:02

0

Thanks for your comments

I got answer to this question either by making the table or just that field is UT8 encoded or using CONVERT(field_name USING utf8) in the query

answered Aug 17 '17 at 06:02

Ha Dev

1 Answers1