Here's one Mysql developer's response to adding (fixing) the integer/bigint/tinyint types to their CAST function:
http://bugs.mysql.com/bug.php?id=34562