The following table 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 |