PHP 4.0 Bug #9267 Updated: vars are set to "" instead of NULL

ID: 9267 Updated by: jmoore Reported By: phanto@php.net Old-Status: Open Status: Closed Old-Bug Type: *Database Functions Bug Type: MySQL related Assigned To: Comments: This seems due to PHP assuming MySQL's return values are strings, which point it is converted into an empty sting. Probably your best bet is to test for a "". I think this behaviour is documented somewhere. James Previous Comments: --------------------------------------------------------------------------- [2001-02-22 13:30:58] phanto@php.net <?php $db = mssql_connect("localhost", "xxx", "yyy"); mssql_select_db("zzz", $db); $result = mssql_query("select NULL as test", $db); mssql_fetch_row($result); $blah = mssql_result($result, 0, "test"); $huh = NULL; echo is_null($blah); // false var_dump($blah); // bool(false) echo is_null($huh); // true var_dump($huh); // NULL ?> --------------------------------------------------------------------------- [2001-02-22 05:26:38] stas@php.net Could you provide a short example of a code that reproduces this? --------------------------------------------------------------------------- [2001-02-14 17:06:49] phanto@php.net don't know if this is only related to the mssql extension, but when i retrieve a NULL - field from the database the var will be set to "" or 0 or whatever in php. is_null() returns false. harald. --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9267&edit=2