Interesting here... I think that you cannot convert from bigint to int if the range is exceeded otherwise from int to bigint I try and it works!

There is the ranges for the numeric datatypes:

bigint -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)

int -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)

smallint -2^15 (-32,768) to 2^15-1 (32,767)

tinyint (0 to 255)

:w00t: