Previous Topic Next topic Print topic


Numeric Limits

Item Limit
Smallest SMALLINT value -32,768
Largest SMALLINT value 32,767
Smallest INTEGER value -2,147,483,648
Largest INTEGER value 2,147,483,647
Smallest DECIMAL value 1-10E+31
Largest DECIMAL value 10E+31-1
Largest decimal precision 31
Smallest 4-byte float value 1.2E-38
Largest 4-byte float value 3.4E+38
Smallest 8-byte float value 2.2E-308
Largest 8-byte float value 1.8E+308
Largest money value $10E+12
Smallest money value -$10E+12
Previous Topic Next topic Print topic