Attribute

MaxVarcharSize (mxvs)

Purpose

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 2147483647.

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 2147483647. For instance, concatenating two columns that are each defined as VARCHAR(10) will result in a VARCHAR(2147483647) rather than a VARCHAR(20). The unnecessarily long size can result in undesirable behavior in some JDBC applications.

Default Value

64000