I'm facing a problem when trying to search for a specific string. The problem is, in the database I have both strings, for example:
When I type
Joao in the search field, it should return both strings:
Joao. The same should happen if I typed
What I'm trying to do is ignoring the accentuation.
This is executed with
QueryBuilder by running a
I've already tried to use
LIKE "%$term%" collate utf8_general_ci but it throws me an error.
By the way, the table collation is already set as
Thank you in any advance.