Hello! I'm having a problem while doing a search with like mysql. Mine table is type MyISAM, colation latin1_swedish_ci.
I'm using php and queries using like are not returning expected results!
If I search for example employees
SELECT * FROM clientes WHERE bairro like '%funcionarios%'
I do not get any records, only returns if I have employee accents.
In the database the data was written by php utf8 the field recorded is Employees
I think failure is due to the type as it was written to the database!
I'd like to know how to resolve this situation so you can search using like without taking accents into account! Doing the direct search in the database also does not return a result using the accented expression.