searching DB that has french characters
Posted: Tue Feb 15, 2005 10:47 am
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.
I would also like to keep the addslashes above.
Thank you
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);Thank you