Welcome Guest, Not a member yet? Register   Sign In
unsigned int vs unsigned big int.
#1

[eluser]megabyte[/eluser]
I've always just used an unsigned int as my auto increment id column.

But lately been thinking, just how many records can be stored.

Well the answer is for int:

4294967295

and for big int

18446744073709551615


Now usually I'd say an int would be enough but I have come across asituation where I'm worried it won't be.


Does anyone use big int? Would this not just be a best practice?

Can anyone explain?
#2

[eluser]SpooF[/eluser]
Twitter: ID number and rising, 8992747620

http://www.twitpocalypse.com/




Theme © iAndrew 2016 - Forum software by © MyBB