SQL Database information limit

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?

 

problem solved, i used varchar instead of int()

 

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

 

yh i realise that after changing all the fields lol :S thanks

 

Super, im glad that helped!!
Good luck with your new game.