From: dsauneuf at guillemot dot fr
Operating system: Windows
PHP version: 5.2.6
PHP Bug Type: MSSQL related
Bug description: Empty string replaced with blank character
Description:
------------
Empty string turned into a blank character.
-----------
Running a php site under windows 2003 / IIS / ntwdblib.dll
(2000.80.2039.0) to access an SQL server 2000 database.
Same thing under Windows XP / IIS / ntwdblib.dll.
Works fine under fedora / apache / freetds.
Denis
Reproduce code:
---------------
$sql=" select '' ";
$res_id=mssql_query($sql)or die ("Database Error");
$row=mssql_fetch_row($res_id);
echo strlen($row[0]);
Expected result:
----------------
Should return 0.
Actual result:
--------------
Returns 1.
--
Edit bug report at http://bugs.php.net/?id=45652&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=45652&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=45652&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=45652&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=45652&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=45652&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=45652&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=45652&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=45652&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=45652&r=support
Expected behavior: http://bugs.php.net/fix.php?id=45652&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=45652&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=45652&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=45652&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=45652&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=45652&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=45652&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=45652&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=45652&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=45652&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=45652&r=mysqlcfg
