user2538055 user2538055 - 2 months ago 21
MySQL Question

preg_rlike not matching characters like ò , í , è etc

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 Source

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