#45652 [Opn->Bgs]: Empty string replaced with blank character
| From: | derick@php.net | Date: | Tue, 29 Jul 2008 10:50:10 +0000 |
| Subject: | #45652 [Opn->Bgs]: Empty string replaced with blank character | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-127376@lists.php.net to get a copy of this message | ||
ID: 45652
Updated by: derick@php.net
Reported By: dsauneuf at guillemot dot fr
-Status: Open
+Status: Bogus
Bug Type: MSSQL related
Operating System: Windows
PHP Version: 5.2.6
New Comment:
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same.
Thank you for your interest in PHP.
This has been submitted *many* times already, and it is also expected
behavior. It's simply how MSSQL works.
Previous Comments:
------------------------------------------------------------------------
[2008-07-29 10:43:39] dsauneuf at guillemot dot fr
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 this bug report at http://bugs.php.net/?id=45652&edit=1