Searching a database with accents

[valterg]

Hello:

We have a database in MySQL that contains data with accentuated characters (Brazilian Portuguese). The scripts system is in PHP.

When it is made a search in this database, the system seeks and it returns records from the database that match exactly the characters, as they were typed. For instance: if the user types in the search field "São José" (accented), the system doesn't find records that contains "Sao Jose" (without accents). Still, if the search is made by "Sao Jose" (without accents), the system doesn't find records that contains "São José" (accented).

Does some way exist that PHP/MySQL returns all of the occurrences in function of the characters, ignoring its accentuation, in other words, independently if the characters in the database OR search field are or not accentuated?

Thank you very much

Valter - Brazil

[Sxooter]

While there are plenty of areas where MySQL is a good choice, when it comes to locale support, you should probably look at postgresql, which has excellent multi-byte and locale support. by setting your locale properly you should be able to handle this kind of thing easily.

[valterg]

Hello:

Thanks for your help. Unfortunatelly, I can't change from MySQL, so I'm seeking for solution using PHP and MySQL.

Valter

[spags]

I am faced with the same problem.

Any Luck?