I am running MySAL 5 on WinXP.
I have created 2 columns, one with bigint, and the other with unsigned bigint.
By theory, the largest number which can fit in bigint is -0.9E19 to 0.9E19 and the largest number which can fit in unsigned is 2 ^ 64 (1.8E19)
When I tried to insert 1.7E19 into both column, the operation shows "out of range" error message (this is expected) for bigint. The operation on unsigned bigint shows OK, but when I check the value, it is 9223372036854775808 (1.8E19 / 2)
So whatever the value is larger than 9223372036854775808, it will shows OK, but the value will be stored as 9223372036854775808.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.