You often need to do things like this with DBD::SQLite too. SQLite only does strings, but if you pass a number to the $sth->execute() method it gets terribly confused. An easier work-around though than explicitly passing the type is to say $sth->execute('' . $number).

Maybe $sth->execute(0 + $number) will convince DBD::Mysql in your case.