You should probably run this past the MySQL mailing list. They'll have a lot more success on how to search the database like this.
-Ed > -----Original Message----- > From: Karl Timmermann [mailto:[EMAIL PROTECTED] > Sent: Saturday, August 14, 2004 12:16 PM > To: [EMAIL PROTECTED] > Subject: [PHP] Language Searching > > 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! > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
