ID: 26820
Updated by: fmk@php.net
Reported By: subspace at wanadoo dot nl
Status: Assigned
Bug Type: MSSQL related
Operating System: Debian Linux 2.4.21
PHP Version: 4CVS-2004-02-06
Assigned To: fmk
New Comment:
On Win32 this is caused by a bug in dblib (the Microsoft library used
to build the extension).
Previous Comments:
------------------------------------------------------------------------
[2004-02-21 05:45:07] egarcia at egm dot as
I have the same problem in Windows XP, Windows 2000, using MSSQL 2000.
I call a store procedure that returns data using rollup over a bit
field. In the sumarized data MSSQL return NULL in the bit field but
PHP give me a zero (0).
The expected result is to get the NULL value data.
The example in the posted message is TOTALLY replicable in my system.
------------------------------------------------------------------------
[2004-02-06 13:44:31] subspace at wanadoo dot nl
./configure --with-mssql --without-mysql
The mysql option is irrelevant though.
FreeTDS package installed: freetds-dev 0.61-5
X-Powered-By: PHP/4.3.5RC2
bit: int(0) tiny: int(0)
bit: int(1) tiny: int(1)
bit: int(0) tiny: NULL
------------------------------------------------------------------------
[2004-02-06 11:35:33] sniper@php.net
One more information is needed: what was the configure line used to
configure PHP?
------------------------------------------------------------------------
[2004-01-19 12:21:11] sniper@php.net
Just to clarify: Expected behaviour is that return values are NULL for
NULL. (definately NOT bool(false) like you suggested in your first
comment)
------------------------------------------------------------------------
[2004-01-19 01:03:59] subspace at wanadoo dot nl
Accidentally clicked hit Submit before I was done typing..
Using 4.3.5RC2-dev CVS 200401190430 and Debian package freetds-dev
0.61-5 the result is now:
X-Powered-By: PHP/4.3.5RC2-dev
bit: int(0) tiny: int(0)
bit: int(1) tiny: int(1)
bit: int(0) tiny: NULL
All the strings are now ints, but as you can see the expected NULL
value is still not there.
------------------------------------------------------------------------
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/26820--
Edit this bug report at http://bugs.php.net/?id=26820&edit=1