What is the best way to bind decimal / double / float values ​​with PDO in PHP?

Question

It seems that class constants only cover PDO::PARAM_BOOL , PDO::PARAM_INT and PDO::PARAM_STR for binding. Are you just binding decimal / float / double values ​​as strings or is there a better way to treat them?

MySQLi allows type 'd' for double, it is surprising that PDO has no equivalent when it seems like it is better for many other ways.

Answer 1

AFAIK PDO :: PARAM_STR is the way to go.

Answer 2

You should use PDO :: PARAM_STR, but for SQLite and other engines this can have unpredictable behavior. See this problem for one example: SQLite HAVING comparison error

Answer 3

If you really want to use PDO, you will need to enter it as PARAM_INT , but I never use the specification for double .

This is an optional parameter to indicate the type of PDO .

I think you better not set the PDO type for double s.