ID: 26835
Updated by: [EMAIL PROTECTED]
Reported By: skissane at ics dot mq dot edu dot au
-Status: Open
+Status: Feedback
Bug Type: MSSQL related
Operating System: Solaris 2.6
PHP Version: 4.3.4
New Comment:
This seams to be a problem on Solaris or FreeTDS. I've tested the code
on Linux and Win32 and can't reproduce the problem.
The code is designed to return NULL if the db-api returns zero length
data. For some reson NULL bust be translated into a non zero length
value on Solaris.
Previous Comments:
------------------------------------------------------------------------
[2004-01-07 22:17:35] skissane at ics dot mq dot edu dot au
Description:
------------
The following script returns an empty string on Solaris, when it should
return a NULL (which it does, correctly, on Linux.)
This is using FreeTDS 0.61.2 (same problem occurs with FreeTDS 0.52).
This is talking to a SQL Server 2000 using TDS version 7.0 (switching
to 8.0 made no difference).
I've checked, and:
mssql.compatability_mode = Off
in php.ini.
Reproduce code:
---------------
<?
$id = mssql_connect("<servername>","<username>","<password>");
$q = mssql_query("SELECT NULL",$id);
$f = mssql_fetch_array($q);
echo gettype($f[0]);
Expected result:
----------------
NULL
Actual result:
--------------
string
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=26835&edit=1
