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.

Data Source Methods

public Integer getMaxVarcharSize()

public void setMaxVarcharSize(Integer)

Default Value

64000

Data Type

Integer