PDO bind data type and comparison

I have an integer column in a table and when I do a comparison the following code seems to work.

$myLimit = 10;
开发者_如何学JAVA$sth = $db->prepare("SELECT * FROM table WHERE number<:myLimit");
$sth->bindParam(':myLimit',$myLimit); // default datatype is PDO::PARAM_STR
$sth->execute();
$result = $sth->fetchAll();

Should I be using PDO::PARAM_INT for the third parameter for bindParam? Also what about real numbers I can't use PDO::PARAM_INT for them as it will round them.

Number handling in PHP is notoriously bad. To pass big numbers around, my advice would be to keep them as strings.

Edit I've just tested the number handling; PARAM_INT works fine for large numeric strings, so you don't have to use PARAM_INT but there's no harm in being precise :)

As for floats, you should pass them using PARAM_STR to massively lose precision.