RE: [PHP] Language Searching
| From: | Ed Lazor | Date: | Sat, 14 Aug 2004 20:30:35 +0000 |
| Subject: | RE: [PHP] Language Searching | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-193831@lists.php.net to get a copy of this message | ||
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:timmerk@comcast.net]
> Sent: Saturday, August 14, 2004 12:16 PM
> To: php-general@lists.php.net
> 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