#30962 [Com]: Space being returned for NULL columns

ID: 30962 Comment by: rantal at eoss dot ru Reported By: richard dot quadling at bandvulc dot co dot uk Status: No Feedback Bug Type: MSSQL related Operating System: Windows XP Pro SP2 PHP Version: 5.0.3 New Comment: Same problem still exist in php4 snapshot php4-win32-STABLE-200503230530.zip Previous Comments: ------------------------------------------------------------------------ [2005-03-17 17:59:57] beschr at free dot fr I've got this problem too with php 5.0.3 on IIS/Windows XP Pro SP2. With the mssql.dll of this snaps: Built On: Mar 17, 2005 01:30 GMT it work great. So I think the correction in CVs is ok and you can close this bug. ------------------------------------------------------------------------ [2005-03-08 01:00:11] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2005-02-28 21:19:22] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip ------------------------------------------------------------------------ [2005-02-15 19:13:23] erudd at netfor dot com -- The reason I say this, is that if I make the column NULL, -- then I get NULL. If I make the column an empty string -- (i.e. select all and then delete - doing this in -- Enterprise Manager), I get a space in the result set! I recently came across this issue when upgrading to the lastest FreeTDS and the lastet PHP 4.3.x connecting to MS SQL Server 2000. The issue was actualy not php, as it was easily fixed by editing the freetds.conf and set the global "tds version" from 4.2 to 7.0 and the space issue went away. ------------------------------------------------------------------------ [2005-01-12 21:15:26] public at nexia dot ca I second the request by wchannospam at tomoye dot com to port this bug fix to 4.3.x stream. Its causing major issues for my PHP apps on Windows. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/30962 -- Edit this bug report at http://bugs.php.net/?id=30962&edit=1