Description: ------------ Integer values are passed correctly to the database backend (DB2 via ODBC) float values are being quoted. That quote is imho a bug. Float values have also passed unquoted to the database backend. Test script: --------------- $dbh->query($update, array(2, 3.5, 4.5, 24)); Expected result: ---------------- correct statemend passed to the db with unquoted numeric values Actual result: -------------- integers are unquoted, floats are quoted: from the DB2 trace: UPDATE policy SET spam_tag_level = 2, spam_tag2_level = '3.5', spam_kill_level = '4.5' WHERE id = 48

due to an upload problem here the really short patch: Index: common.php =================================================================== --- common.php (revision 24) +++ common.php (working copy) @@ -442,7 +442,9 @@ if (is_int($in)) { return $in; } elseif (is_float($in)) { - return $this->quoteFloat($in); + if ($this->dbsyntax == 'db2') { + return $in; + } else return $this->quoteFloat($in); } elseif (is_bool($in)) { return $this->quoteBoolean($in); } elseif (is_null($in)) {

What happens? When I was fixing the DB2 driver for PEAR DB (years ago), I never ran into any problems along these lines when running PEAR DB's test suite.