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.

Answer 1

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