Queries with mysql LIKE Operator

Question

Hello! I’m having a problem doing a search with like mysql. My table is type Myisam, colation latin1_swedish_ci.

I’m using php and queries using like are not returning expected results!

If I look for employees for example

SELECT * FROM clientes WHERE bairro like '%funcionarios%'

I get no record, only returns if you have with employee accent.

in the database the data were recorded by php utf8 the field recorded is Funcionã¡rios

I think the failure is due to the type as it was recorded in the database!

I would like to know how to resolve this situation so that you can search using like without taking into account the accents! Doing the direct search in the database also does not return result using the accent expression.