ID: 26315 Comment by: w1lz0r at barrysworld dot net Reported By: webmaster at cbre dot fr Status: Bogus Bug Type: MSSQL related Operating System: Windows 2000 Server PHP Version: 4.3.4 New Comment:
This is a bug, as there is no space in the database. The change from not auto-trimming is a good one IMO, but the behaviour of empty fields is different now. Any character field which is empty (e.g. '') and not null will be returned as a space. My application no longer worked correctly after the 4.3.4 change and I have to now manually do (if ($field==' ') $field='';). This is a major change from previous versions and a bug as the mssql functions should return what is IN the database. Maybe this is the reason why the rtrim was done in the past? Please re-evaluate. Previous Comments: ------------------------------------------------------------------------ [2003-11-19 09:42:17] [EMAIL PROTECTED] Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php mssql extension no longer automatically trims varchar fields ------------------------------------------------------------------------ [2003-11-19 07:20:52] webmaster at cbre dot fr Description: ------------ mssql_fectch_* functions are returning a space char when selecting empty fields. The problem does not occur where MSSQL table fields are set to <NULL> value insteed of empty. It was not working this way with PHP 4.3.2 and previous versions. I can't see nothing in the change log about this. Kind regards Clement ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=26315&edit=1
