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.