MySQL Forums
Forum List  »  Quality Assurance

big INT issue/bug
Posted by: Aaron McKelvie
Date: August 29, 2007 02:07AM


I'm having some problems with something in my database, I'm not sure why it is happening, but here goes.

I have a PHP script which adds money to a user's bank, the bank feild uses bigInt with a length of 40. bigINT(40).

However, if the bank of a user surpasses 1trillion (1,000,000,000,000) then it resets to 0. I thought bigINT supported far larger numbers? Why is it happening??

Thanks for your time. Any help greatly appreciated.

PS . I'm not certain why this is happening, so it's hard for me to report it as a bug.. Unless I'm doing something stupid wrong, which would solve everything.

Edited 1 time(s). Last edit at 08/29/2007 02:10AM by Aaron McKelvie.

Options: ReplyQuote

Written By
big INT issue/bug
August 29, 2007 02:07AM
August 29, 2007 09:55AM

Sorry, you can't reply to this topic. It has been closed.

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.