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

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 10,485,760. For instance, concatenating two columns that are each defined as VARCHAR(10) will result in a VARCHAR(10485760) 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

10,485,760

Data Type

Integer