It sounds like Zeos is checking the value of the number and reducing it's data type if it can (for efficiency I guess). If cast isn't available in your version of MySQL you might try Convert().
Here's a manual link: http://www.mysql.com/doc/en/Cast_Functions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]