ID: 26315
Comment by: jabberwocky at ibplanet dot com
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:
also, instead of returning 0 it is now also returning a space if there
is a 0 in the DB
Previous Comments:
------------------------------------------------------------------------
[2003-11-21 07:56:06] w1lz0r at barrysworld dot net
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.
------------------------------------------------------------------------
[2003-11-19 09:42:17] iliaa@php.net
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