ID: 26820
Updated by: fmk@php.net
Reported By: subspace at wanadoo dot nl
-Status: Assigned
+Status: Closed
Bug Type: MSSQL related
Operating System: Debian Linux 2.4.21
PHP Version: 4CVS-2004-02-06
Assigned To: fmk
New Comment:

This problem has been fixed in FreeTDS. Works on both Windows and
Linux.


Previous Comments:
------------------------------------------------------------------------

[2004-10-18 20:39:06] freddyz77 at tin dot it

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).

------------------------------------------------------------------------

[2004-02-25 14:53:26] fmk@php.net

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] sniper@php.net

One more information is needed: what was the configure line used to
configure PHP?


------------------------------------------------------------------------

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