Hi, Does anyone how I could accomplish this:
Basically, I have a MySQL database of names - some names have Spanish accents in them. I want to build a web interface in PHP to search this database. However, I want the names with Spanish accents to be shown in the search results, regardless if the search was spelled without the accents.
For example:
The database has "Niņo" in it. I want it to be returned if the user searched by using "nino" or "niņo".
Any ideas? Maybe somehow using regular expressions in PHP or in MySQL using Unicode somehow?
It has to be fast and on the fly. Thanks!
