ID: 30962 Updated by: php-bugs@lists.php.net Reported By: richard dot quadling at bandvulc dot co dot uk -Status: Feedback +Status: No Feedback Bug Type: MSSQL related Operating System: Windows XP Pro SP2 PHP Version: 5.0.3 New Comment:
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". Previous Comments: ------------------------------------------------------------------------ [2005-02-28 21:19:22] [EMAIL PROTECTED] 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. ------------------------------------------------------------------------ [2005-01-12 21:02:43] wchannospam at tomoye dot com This problem is also appearing in PHP 4.3.x where x>=4. Can you implement the same fix there as well. Thank you very much. ------------------------------------------------------------------------ [2004-12-16 11:39:16] richard dot quadling at bandvulc dot co dot uk Simple test script to show the problem. <?php $rConn = mssql_connect('localhost','PHPBB_User','PHPBB_User'); $rResults = mssql_query('SELECT username, user_icq, LEN(user_icq) AS user_icq_len FROM PHPBB_User.phpbb_users'); while ($row = mssql_fetch_assoc($rResults)) { echo '<pre>' . var_export($row, True) . '</pre>Length of ' . $row['username'] . '\'s user_icq = ' . strlen($row['user_icq']) . '<br /><br /><br />'; } mssql_free_result($rResults); mssql_close($rConn); ?> Requires phpBB and at least 1 user defined with an ICQ number. Obviously, you could choose any field or any other MS SQL database. Richard. ------------------------------------------------------------------------ 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