#20506 [NEW]: insert null value into float/double mysql gives 0

From: haagsepatrick@hotmail.com Operating system: Windows98 PHP version: 4.2.1 PHP Bug Type: MySQL related Bug description: insert null value into float/double mysql gives 0 In short: $specialprice="Null"; $query = "UPDATE mytable SET mytable.specialprice = '".$specialprice."' WHERE ......"; submitted a "0"(zero) into mysql. and: $specialprice="mytable.specialprice =Null"; $query = "UPDATE mytable SET '".$specialprice."' WHERE ......"; submitted Null, like it should. I couldnt account why the first version would submit "0" the mysql field has the following properties: type:float, length=11, decimals=2, allow null:true, unsigned: false, zerofill: false, default value:empty -- Edit bug report at http://bugs.php.net/?id=20506&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=20506&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=20506&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=20506&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=20506&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=20506&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=20506&r=support Expected behavior: http://bugs.php.net/fix.php?id=20506&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=20506&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=20506&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=20506&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=20506&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=20506&r=dst IIS Stability: http://bugs.php.net/fix.php?id=20506&r=isapi