Datatypes by category |
Synonyms |
Range |
Bytes of storage |
Exact numeric: integers | |||
tinyint |
0 to 255 (Negative numbers are not permitted.) |
1 | |
smallint |
215 -1 (32,767) to -215 (-32,768) |
2 | |
int |
integer |
231 -1 (2,147,483,647) to -231 (-2,147,483,648 |
4 |
Exact numeric: decimals | |||
numeric (p, s) |
1038 -1 to -1038 |
2 to 17 |