sql datatypes range

Solutions on MaxInterview for sql datatypes range by the best coders in the world

showing results for - "sql datatypes range"
Eya
15 Apr 2019
1
2Datatypes 
3
4tinyint
5
6Signed Integer ranges 
7-2^8 to 2^8 -1 
8
9Unsigned integer ranges 
100 to 2^8 -1 
11
12Small int 
13
14Signed Integer ranges 
15-2^16 to 2^16-1 
16
17Unsigned integer ranges 
180 to 2^8 -1 
19
20mediumint 
21
22Signed Integer ranges 
23-2^24 to 2^24 -1 
24
25Unsigned integer ranges 
260 to 2^24 -1 
27
28Integer,int 
29
30Signed Integer ranges 
31-2^32 to 2^32-1 
32
33Unsigned integer ranges 
340 to 2^32-1 
35
36bigint 
37
38Signed Integer ranges 
39-2^64 to 2^64-1 
40
41Unsigned integer ranges 
420 to 2^64-1 
43
44