[Urgent] Can mysql store more than 10 digits?

Discussion in 'Programming' started by Hipto, May 30, 2010.

  1. #1
    One of my table is in this format "MyISAM, latin1_swedish_ci"
    It's a rapidshare traffic checker and, my script will update itself and store it in DB.

    It was working previously, but today, it isn't storing the properly. The CORRECT value is -2 216 558 000. Yes with negative.
    THhe problem is, the script is suppose to delete the account store when traffic is <=
    but it didn't :s when i check the last stored traffic value, it was 5475

    So
    (1) Is it due to php not reading the -2 216 558 000 properly or is it mysql fault?
     
    Hipto, May 30, 2010 IP
  2. Amator

    Amator Well-Known Member

    Messages:
    1,424
    Likes Received:
    55
    Best Answers:
    0
    Trophy Points:
    165
    #2
    Amator, May 30, 2010 IP
  3. flexdex

    flexdex Peon

    Messages:
    104
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Use BIGINT instead of INT and use a higher scale
     
    flexdex, May 30, 2010 IP