Identical query in PHP5 returning different results
Posted: Wed Feb 23, 2005 9:39 am
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.
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
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.