BIGINT (20) error

solata · Post by **solata** » Mon 16 Mar 2009 14:53

In application I get this error: "Overflow while cenverting variant of type (Int64) into type (Integer)".

In MySQL 5.0 field is set to BIGINT(20) - auto increment.

Value
1000000000
and
2000000000
work ok. Select, insert, update,...

Value
3000000000
sends error "Overflow while cenverting variant of type (Int64) into type (Integer)".
It looks like client is trying to convert BIGINT to Integer (values to 2147483647 are ok) insetead to Int64.

MyDAC version 4.40

How can this be solved in database? Is this solved in newer version of MyDAC?

Thanks.

Challenger · Post by **Challenger** » Tue 17 Mar 2009 12:50

We could not reproduce this problem with MyDAC 4.40 and with MyDAC 5.70 as well. Please send us a small sample to reproduce the problem.