mssql query - fixed length column pads with spaces

[menkes]

Using PHP 4.3.9 results from a query DID NOT include spaces at the end of a fixed length column:

select fld from tbl where id = 1
assuming fld is varchar(12)
returns '12345'

I moved my site to a new server using PHP 5.2.8. No changes at all to the database. The same exact query now returns:
'12345 '

Please help...I cannot afford to have to go through all my code to fix this. It must be somewhere in PHP as the exact same database is being used.

 

[menkes]

OK, no need to respond to this. After much digging I found that the automatic trimming of return values was disabled in php_mssql long ago. So, unless someone is upgrading from a pre-2005 version (such as I was), this should not be an issue for anyone.