Page 1 of 1

Identical query in PHP5 returning different results

Posted: Wed Feb 23, 2005 9:39 am
by adrey
Good Morning All. I am not sure if this is a PHP or MSSQL issue however I hope someone can give me some pointers.

We have a website using PHP 4.3.2 (on Linux) We are trying to move some functionality to a new Windows server using PHP5.

Everything works fine - EXCEPT :? - queries which returned an empty string for an empty field with PHP 4.3.2 are returning a blank space when run with PHP5.

I know I can add a trim function - but this affects many different queries accross the site and I am hoping there is some general php/mssql setting which would take care of this.

According to PHP this is not a bug. (?But no explanation how to work with it or what causes it)
According to mssql - setting the database compatability to level 8 should correct the issue. However our database is already set with that compatability level. Besides - it is the exact same database that is being called from php 4.3.2 ??!!

I hope I explained the issue clearly. If anyone has any tips or suggestions I would really appreciate it.

Thanks.