Attribute

VarcharThreshold (VT)

Purpose

Specifies the threshold at which the driver describes columns of the data type SQL_(W)VARCHAR as SQL_(W)LONGVARCHAR. If the size of the SQL_(W)VARCHAR column exceeds the value specified, the driver will describe the column as SQL_(W)LONGVARCHAR when calling SQLDescribeCol and SQLColumns. This option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_(W)VARCHAR type for some third-party applications.

Valid Values

x

where:

x
is the maximum size in characters of columns the driver will describe as SQL_(W)VARCHAR.

Notes

  • Configuring the VarcharThreshold and MinLongVarcharSize options allows you to fetch SQL_(W)VARCHAR and SQL_(W)LONGVARCHAR columns with sizes that fall between the data-type ranges used by some applications.

Default

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

GUI Tab

Advanced tab

See also