SQL Database information limit

Discussion in 'Databases' started by JustCause, Jun 6, 2009.

  1. #1
    Ive been working on a mmorpg game for a while now (altho i have seen this problem on other rpg scripts) its basically a turn based game where users can scout etc for thugs. Basically the problem is i cannot get more than 2147483648 thugs or above the same value in networth and i have learnt that this is database lmit issue, but i have seen many other games where you can get loads more thugs than that and they are running an SQL database.

    just wondering if their is anyway to lift the database limits?
     
    JustCause, Jun 6, 2009 IP
  2. JustCause

    JustCause Guest

    Messages:
    192
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    problem solved, i used varchar instead of int()
     
    JustCause, Jun 6, 2009 IP
  3. *LESTAT*

    *LESTAT* Peon

    Messages:
    97
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    actually, what you should have changed was your (int) to bigint. Varchar will allow letters and numbers when your int/biginit are for numbers only hence integers. (int) and (bigint) for big numbers
     
    *LESTAT*, Jun 6, 2009 IP
  4. JustCause

    JustCause Guest

    Messages:
    192
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    yh i realise that after changing all the fields lol :S thanks :)
     
    JustCause, Jun 7, 2009 IP
  5. *LESTAT*

    *LESTAT* Peon

    Messages:
    97
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Super, im glad that helped!! :)
    Good luck with your new game.
     
    *LESTAT*, Jun 7, 2009 IP