Re: 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 > 1) not mysql, mssql 2. it means that the mssql_result call failed for some reason, because false was returned, not an empty string. still, the bug should be closed ;-) -Sterling > 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 > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >