search string shows wrong results with special characters.

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
bipulagarwal
Forum Newbie
Posts: 3
Joined: Wed Jan 28, 2009 2:19 am

search string shows wrong results with special characters.

Post by bipulagarwal »

Hi All,

I have been wasting my time since yesterday to figure out a search string which shows incorrect results when queried in PHP 4.4.7 version. Same files with same database shows correct results when we run it on another hosting server with PHP version 4.4.9.

problem - while making a search in PHP version 4.4.9 for a keyword like - åre it shows 26 results which is correct.
But, when we run the same query in PHP version 4.4.7 it shows over 11000 records which is wrong.

Special characters are displayed properly on the browser but the only problem is while searching them from database (over 200,000 records in database).

I have a deadline tomm and still couldn't find a solution. Help, any one?
Thanks
Bipul
bipulagarwal
Forum Newbie
Posts: 3
Joined: Wed Jan 28, 2009 2:19 am

Re: search string shows wrong results with special characters.

Post by bipulagarwal »

I forgot to mention that our hosting server with php version 4.4.9 is in Singapore and the other server with 4.4.7 is based in London... just in case if it strikes out something to you..
Thanks
Bipul
Post Reply