Hello, I have a system in php / mysql using zend 1.12, but when I query the mysql database with a word that does not have an accent and the table has an accent, it does not return any results, for example:
When searching: {joao} and in the database this {joão}, does not return results.
The database is configured with: InnoDB latin1_general_ci.
I want to know if I have to remove the accents of the records that are already in the table for the query to occur naturally when the user searches for words without an accent.
ex: user type: {atencao} in the table I have the phrase: {Be very careful to pay attention when returning from the trip.}
this returns 0 result.
I do not know if I could be clear, I already tried the forum here and found nothing similar.
If someone can indicate a link or give some tips or even clarify this.
Thank you.