apache > db
Apache DB Project
 
Font size:      

Numeric limitations

Numeric limitations


Table 29. Numeric limitations

The following table contains limitations on numeric values in Derby.
ValueLimit
Smallest INTEGER-2,147,483,648
Largest INTEGER2,147,483,647
Smallest BIGINT-9,223,372,036,854,775,808
Largest BIGINT9,223,372,036,854,775,807
Smallest SMALLINT-32,768
Largest SMALLINT32,767
Largest decimal precision31,255
Smallest DOUBLE-1.79769E+308
Largest DOUBLE1.79769E+308
Smallest positive DOUBLE2.225E-307
Largest negative DOUBLE-2.225E-307
Smallest REAL-3.402E+38
Largest REAL3.402E+38
Smallest positive REAL1.175E-37
Largest negative REAL-1.175E-37

Previous Page
Next Page
Table of Contents
Index