skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The DB2 Wire Protocol Driver : Connection Option Descriptions for DB2 : Varchar Threshold
 
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 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