PHP 4.0 Bug #6527 Updated: empty field returned are not empty
| From: | Bug Database | Date: | Mon, 04 Sep 2000 10:56:01 +0000 |
| Subject: | PHP 4.0 Bug #6527 Updated: empty field returned are not empty | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-31919@lists.php.net to get a copy of this message | ||
ID: 6527
User Update by: lenar@city.ee
Status: Open
Bug Type: Sybase-ct (ctlib) related
Description: empty field returned are not empty
And don't say it's sybase's fault. At least in ISQL it works. It's ASE 6 here
and in ISQL over ctlib I get very proper results:
SELECT '**', '*'+phone+'*', LENGTH(phone) FROM users WHERE
LENGTH(phone) = 0
result records:
** ** 0
** ** 0
not:
** * * 0
or something more bizarre.
So please check it out.
Lenar
Previous Comments:
[2000-09-04 06:44:56] lenar@city.ee
When fetching a record from sybase with sybase_fetch_row
and some fields contain no value ("") then in resulting array there are spaces instead.
list($space) = sybase_fetch_row(sybase_query("SELECT phone FROM users WHERE LENGTH(phone) =
0"));
now $space == " ".
This is not what I want. I want strlen($space) == 0.
Hope this bug will be fixed.
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=6527