Page 1 of 1

search string shows wrong results with special characters.

Posted: Wed Jan 28, 2009 7:13 am
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

Re: search string shows wrong results with special characters.

Posted: Wed Jan 28, 2009 7:18 am
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