Page 1 of 1

searching DB that has french characters

Posted: Tue Feb 15, 2005 10:47 am
by grudz
Hello,

I am having a problem with french characters, it's not how to display them but rather searching for them.

Let`s say 2 items in my DB is called éléphant, and elephant

And if a user searches for anything with "é" i would like only the éléphant to show. The way it's now, both will

This is how my code is set up now.

Code: Select all

$quicksearch_List = (get_magic_quotes_gpc()) ? $_GETї'quicksearch'] : addslashes($_GETї'quicksearch']);

$query_List = sprintf("SELECT package, name, streetnumber, address, addressinfo, description, type, events, food, music, location, days, icons FROM listing WHERE name LIKE '%%%s%%'", $quicksearch_List);
I would also like to keep the addslashes above.

Thank you