The following lists limitations on the numeric values in Derby.
| Value | Limit |
|---|---|
| Largest negative INTEGER | -2,147,483,648 |
| Largest positive INTEGER | 2,147,483,647 |
| Largest negative BIGINT | -9,223,372,036,854,775,808 |
| Largest positive BIGINT | 9,223,372,036,854,775,807 |
| Largest negative SMALLINT | -32,768 |
| Largest positive SMALLINT | 32,767 |
| Largest decimal precision | 31 |
| Largest negative DOUBLE | -1.7976931348623157E+308 |
| Largest positive DOUBLE | 1.7976931348623157E+308 |
| Smallest negative normalized DOUBLE | -2.2250738585072014E-308 |
| Smallest positive normalized DOUBLE | 2.2250738585072014E-308 |
| Smallest negative denormalized DOUBLE | -4.9E-324 |
| Smallest positive denormalized DOUBLE | 4.9E-324 |
| Largest negative REAL | -3.4028235E+38 |
| Largest positive REAL | 3.4028235E+38 |
| Smallest negative normalized REAL | -1.17549435E-38 |
| Smallest positive normalized REAL | 1.17549435E-38 |
| Smallest negative denormalized REAL | -1.4E-45 |
| Smallest positive denormalized REAL | 1.4E-45 |