Purpose

Specifies the threshold at which the driver describes character columns as type LONGVARCHAR. This property allows you to fetch columns that would otherwise exceed the upper limit of the VARCHAR type for some third-party applications, such as SQL Server Linked Server.

Valid Values

x

where:

x

is the maximum size in characters of columns the driver will describe as VARCHAR.

Notes

  • For STRING columns, the driver determines the column size to be 50% greater than the longest sampled value in the column. This behavior allows for values larger than those identified through sampling. If the adjusted column size exceeds the value specified for this property, the driver describes the column as LONGVARCHAR when calling SQLDescribeCol and SQLColumns.

Data Source Methods

public Integer getVarcharThreshold()

public void setVarcharThreshold(Integer)

Default Value

4000

Data Type

Integer