PHP 4.0 Bug #6527 Updated: empty field returned are not empty

ID: 6527 Updated by: joey Reported By: lenar@city.ee Status: Open Bug Type: Sybase-ct (ctlib) related Assigned To: Comments: Note that the empty string is NOT the same thing in Sybase as a null...here's what ISQL shows us. 1> select "**", "*"+OPP_VOLUNTEERS_NEEDED+"*" from OPPORTUNITY 1> where OPP_VOLUNTEERS_NEEDED = NULL 2> go -- ----------------- ** ** ** ** <... snip ...> (18 rows affected) 1> 1> select "**", "*"+OPP_VOLUNTEERS_NEEDED+"*" from OPPORTUNITY 1> where OPP_VOLUNTEERS_NEEDED = "" 2> go -- ----------------- ** * * <... snip ...> ** * * ** * * (389 rows affected) 1> And what version of Sybase ASE are you using? 6.0? There is no (AFAIK) Linux port earlier than 11.5, so something is definitely wrong here. Previous Comments: [2000-09-04 06:56:01] lenar@city.ee 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 --------------------------------------------------------------------------- [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