String limitations

The following table lists limitations on string values in Derby.

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