|Subject:||bind_param(..., SQL_FLOAT) ignores exponents|
bind_param(..., SQL_FLOAT) does not recognize the exponents of suppiled values. For example, the code below should print 1e16 but shows "1" instead. It seems that the parse_number function in dbdimp.c is simply ignoring the "eXX" portion of the floating point representation. my $sth = $dbh->prepare('select ?') or die $dbh->errstr; $sth->bind_param(1, 1e16, SQL_FLOAT) or die $dbh->errstr; $sth->execute() or die $dbh->errstr; print $sth->fetchrow_arrayref()->, "\n"; # should print 1e16, but shows "1"