String limitations
The following table lists limitations on string values in
.
limitationsstring values
string valueslimitations
String limitations
This table lists the limitations on string values.
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