Determines the maximum size of VARCHAR columns when described within the result set metadata.
Valid Values
x
where:
x
is an integer greater than or equal to 1 and less than or equal to 4096.
Notes
When string functions are used within the Select list of a Select statement, the driver describes the resulting string value with a size of 4096. For instance, concatenating two columns that are each defined as VARCHAR(10) will result in a VARCHAR(4096) rather than a VARCHAR(20). The unnecessarily long size can result in undesirable behavior in some JDBC applications.
