skip to main content
Connection Properties Reference : Varchar Threshold
 

Try DataDirect Cloud Now

Varchar Threshold

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 Varchar Threshold and Min Long Varchar Size 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 does not change the described type for SQL_VARCHAR columns.

GUI tab

Advanced tab

See also

MinLongVarcharSize