The following table lists 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 |