sql datatypes range
Datatypes
tinyint
Signed Integer ranges
-2^8 to 2^8 -1
Unsigned integer ranges
0 to 2^8 -1
Small int
Signed Integer ranges
-2^16 to 2^16-1
Unsigned integer ranges
0 to 2^8 -1
mediumint
Signed Integer ranges
-2^24 to 2^24 -1
Unsigned integer ranges
0 to 2^24 -1
Integer,int
Signed Integer ranges
-2^32 to 2^32-1
Unsigned integer ranges
0 to 2^32-1
bigint
Signed Integer ranges
-2^64 to 2^64-1
Unsigned integer ranges
0 to 2^64-1