skip to main content
Connection Option Descriptions : Varchar Threshold
  

Try DataDirect Drivers Now

Varchar Threshold

Attribute

VarcharThreshold (VT)

Purpose

Specifies the threshold at which the driver describes columns of the data type VARCHAR as LONGVARCHAR. If the size of the VARCHAR column exceeds the value specified, the driver will describe the column as LONGVARCHAR when calling SQLDescribeCol and SQLColumns. 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

*Configuring the VarcharThreshold and MinLongVarcharSize options allows you to fetch VARCHAR and LONGVARCHAR columns with sizes that fall between the data-type ranges used by some applications, such as SQL Server Linked Server.

Default

None. If no value is specified, the driver will not change the described type for VARCHAR columns.

GUI Tab

Advanced tab

See also

Min Long Varchar Size