String limitations

Table 1. String limitations. The following table contains limitations on string values in Derby.
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 manager values
DATE, TIME, and TIMESTAMP limitations
Limitations on identifier length
Numeric limitations
XML limitations