String limitations
Derby Reference Manual
394
Value
Limit
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
String limitations
The following table lists limitations on string values in Derby.
Table 138.
String limitations
Value
Maximum Limit
Length of CHAR
254 characters
Length of VARCHAR
32,672 characters
Length of LONG VARCHAR
32,700 characters
Length of CLOB
2,147,483,647 characters
Length of BLOB
2,147,483,647 characters
Length of character constant
32,672
Length of concatenated character string
2,147,483,647
Length of concatenated binary string
2,147,483,647
Number of hex constant digits
16,336
Length of DOUBLE value constant
30 characters
XML limitations
The following table lists limitations on XML data types in Derby.
Table 139.
XML limitations
Issue
Limitation
Length of XML
2,147,483,647 characters
