Numeric limitations

The following lists limitations on the numeric values in Derby.

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