The following lists limitations on the numeric values in Derby.
| Value | Limit |
|---|---|
| Smallest INTEGER | -2,147,483,648 |
| Largest INTEGER | 2,147,483,647 |
| Smallest BIGINT | -9,223,372,036,854,775,808 |
| Largest BIGINT | 9,223,372,036,854,775,807 |
| Smallest SMALLINT | -32,768 |
| Largest SMALLINT | 32,767 |
| Largest decimal precision | 31 |
| Smallest DOUBLE | -1.79769E+308 |
| Largest DOUBLE | 1.79769E+308 |
| Smallest positive DOUBLE | 2.225E-307 |
| Largest negative DOUBLE | -2.225E-307 |
| Smallest REAL | -3.402E+38 |
| Largest REAL | 3.402E+38 |
| Smallest positive REAL | 1.175E-37 |
| Largest negative REAL | -1.175E-37 |