Numeric Data Types
Numeric Data Types
| Data Type | Min Value | Max Value | Memory |
|---|---|---|---|
| INT | −2^31 | 2^31−1 | 4 bytes |
| SMALLINT | −2^15 | 2^15 | 2 bytes |
| BIGINT | −2^63 | 2^63−1 | 8 bytes |
| TINYINT | 0 | 255 | 1 byte |
| DECIMAL | −10^38+1 | 10^381−1 | 5 to 17 bytes |
| MONEY | −922,337, 203, 685,477.5808 | +922,337, 203, 685,477.5807 | 8 bytes |
| FLOAT | −1.79E+308 | 1.79E+308 | depends on float precision |
| REAL | −3.40E+38 | 3.40E+38 | 4 bytes |