Restriction: This topic applies to Windows environments only.
| 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 |