Font size:
Numeric limitations
Numeric limitations
Table 29. Numeric limitations
| The following table contains limitations on numeric values in Derby. |
| 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,255 |
| 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 |
Previous Page
Next Page
Table of Contents
Index
