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 |