Attribute

VarcharThreshold (vth)

Purpose

Specifies the threshold at which the driver describes character columns as type LONGVARCHAR. This option 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 option, the driver describes the column as LONGVARCHAR when calling SQLDescribeCol and SQLColumns.

Default Value

4000