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
I don't know whether this is a problem with mySQL or Zeos (freeware Delphi
components), but I'll ask here:
When I use 'count' in a one table query, Zeos defines the resulting field as
TIntegerField. When I use 'count' in a two table query, the resulting field
is TLargeIntField, which causes problem