#48855 [NEW]: Decimals are rounded with PDO bindValue in mysql double/float fields

From: lorenzo-99 at libero dot it Operating system: Windows XP PHP version: 5.2.10 PHP Bug Type: PDO related Bug description: Decimals are rounded with PDO bindValue in mysql double/float fields Description: ------------ I'm inserting a new record in a Mysql table with a PDO routine, the table have a double field (not specified the scale and size for the field), I'm using the bindValue function, I try to save the value 9.1234567 in the field, after the insert I found it saves 9.123457, so maximum 6 decimals (with rounding). The same problem happens with a float field, in this case it saves maximum 5 decimals I didn't try with other dbms, my Mysql version is 5.1.36 (i verified that the problem happens also with older versions) Reproduce code: --------------- This saves only 6 decimal (using bindValue): $sth = $dbh->prepare("INSERT INTO intrapportal.regioni ( idRegione ,descrRegione , provadouble ) VALUES ('xxxx', 'yyyyy', :value)"); /*** bind values ***/ $sth->bindValue(':value', 9.1234567, PDO::PARAM_STR); /*** execute the prepared statement ***/ $sth->execute(); This saves all decimals (without bindValue) $sth = $dbh->prepare("INSERT INTO intrapportal.regioni ( idRegione ,descrRegione , provadouble ) VALUES ('xxxx', 'yyyyy', 9.1234567)"); /*** execute the prepared statement ***/ $sth->execute(); -- Edit bug report at http://bugs.php.net/?id=48855&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=48855&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=48855&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=48855&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=48855&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=48855&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=48855&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=48855&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=48855&r=needscript Try newer version: http://bugs.php.net/fix.php?id=48855&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=48855&r=support Expected behavior: http://bugs.php.net/fix.php?id=48855&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=48855&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=48855&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=48855&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=48855&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=48855&r=dst IIS Stability: http://bugs.php.net/fix.php?id=48855&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=48855&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=48855&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=48855&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=48855&r=mysqlcfg