Android Question mysql weird problem

[tufanv]

Hello

I have an integer value in my sql called money
when i try to set it to 3,000,000,000 within the phpmyadmin ( via update tblusers set money ="3000000000"
it accepts the query than i go check the value of money via phpmyadmin again it says the money is : 2147483647

it is always the same .

Have any ideas ?

 

[Straker]

Simply because a MySql Int type is 4 bytes and the maximum number is 2147483647.
You should use a bigint field (you can ALTER TABLE...)