user2538055 user2538055 - 1 year ago 171
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
but I have many like

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download