ID: 26820
Comment by: freddyz77 at tin dot it
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:
dblib use by default TDS protocol 4.2. This protocol do not support
null bits so it return 0 instead. Use protocol 7.0 or more (8.0 for
mssql2k). This can be configured using FreeTDS (but not using MS
dblib).
Previous Comments:
------------------------------------------------------------------------
[2004-02-25 14:53:26] [EMAIL PROTECTED]
On Win32 this is caused by a bug in dblib (the Microsoft library used
to build the extension).
------------------------------------------------------------------------
[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] [EMAIL PROTECTED]
One more information is needed: what was the configure line used to
configure PHP?
------------------------------------------------------------------------
[2004-01-19 12:21:11] [EMAIL PROTECTED]
Just to clarify: Expected behaviour is that return values are NULL for
NULL. (definately NOT bool(false) like you suggested in your first
comment)
------------------------------------------------------------------------
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
