Numeric limitations

The following table lists limitations on the numeric values in Derby.

Table 1. Numeric limitations
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
Related reference
Limitations for database values
DATE, TIME, and TIMESTAMP limitations
Limitations on identifier length
String limitations
XML limitations