# 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

Parent topic: Derby limitations
Related reference
Limitations for database values
DATE, TIME, and TIMESTAMP limitations
Limitations on identifier length
String limitations
XML limitations