#26820 [Com]: mssql_fetch_row BIT field problem

ID: 26820 Comment by: php at dima dot spb dot ru Reported By: subspace at wanadoo dot nl Status: Open Bug Type: MSSQL related Operating System: Debian Linux 2.4.21 PHP Version: 4CVS-2004-01-19 New Comment: Sorry, forgot to point out the problem. There are actually two of them: 1. Warning: mssql_query(): Sybase: column 1 has unknown data type (104) in /root/xtest.php on line 21 This goes away if I use "NOT NULL" column instead of "NULL" 2. representing bit column with string(21). Obviously, this breaks all the following code... Previous Comments: ------------------------------------------------------------------------ [2004-01-28 10:00:11] php at dima dot spb dot ru When I run the same program from command line, I'm getting: Warning: mssql_query(): Sybase: column 1 has unknown data type (104) in /root/xtest.php on line 21 Warning: mssql_query(): Sybase: column 1 has unknown data type (104) in /root/xtest.php on line 21 bit: string(0) "" tiny: string(21) "0 " bit: string(0) "" tiny: string(21) "1 " bit: string(0) "" tiny: string(0) "" Tried this with php-4.3.4 and php4-STABLE-200401281030. Results are the same. FreeTDS-0.60 Does this make sense to anyone? ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2004-01-19 01:00:23] subspace at wanadoo dot nl 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 ------------------------------------------------------------------------ [2004-01-18 23:02:58] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ 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