Attribute

VarcharThreshold (VT)

Purpose

Specifies the threshold at which the driver describes columns of the data type SQL_VARCHAR as SQL_LONGVARCHAR. If the size of the SQL_VARCHAR column exceeds the value specified, the driver will describe the column as SQL_LONGVARCHAR when calling SQLDescribeCol and SQLColumns. This option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_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_VARCHAR.

Notes

  • Configuring the VarcharThreshold and MinLongVarcharSize options allows you to fetch SQL_VARCHAR and SQL_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_VARCHAR columns.

GUI Tab

Advanced tab

See also

Min Long Varchar Size