PDO::PARAM for type decimal?

Question

I have 2 database fields

`decval` decimal(5,2) `intval` int(3) 

I have 2 pdo queries that update them. The one that updates the int works ok

$update_intval->bindParam(':intval', $intval, PDO::PARAM_INT); 

but I can't update the decimal field. I've tried the 3 ways below, but nothing works

$update_decval->bindParam(':decval', $decval, PDO::PARAM_STR); $update_decval->bindParam(':decval', $decval, PDO::PARAM_INT); $update_decval->bindParam(':decval', $decval); 

It seems the problem is with the database type decimal? Is there a PDO::PARAM for a field of type decimal? If not, what do I use as a workaround?

Answer 1

There isn't any PDO::PARAM for decimals / floats, you'll have to use PDO::PARAM_STR.