Searching database with different languages?
| From: | Karl Timmermann | Date: | Sun, 08 Aug 2004 22:07:38 +0000 |
| Subject: | Searching database with different languages? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-193149@lists.php.net to get a copy of this message | ||
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!