Attribute

MinLongVarcharSize (MINLVS)

Purpose

Specifies the minimum count of characters the driver reports for columns mapped as SQL_(W)LONGVARCHAR. If the size of a SQL_(W)LONGVARCHAR column is less than the value specified, the driver will increase the reported size of the column to this value when calling SQLDescribeCol and SQLColumns. This allows you to fetch SQL_(W)LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications.

Valid Values

x

where:

x
is the minimum size in characters the driver will report for columns mapped to the SQL_(W)LONGVARCHAR type.

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 column size reported for SQL_(W)LONGVARCHAR columns.

GUI Tab

Advanced tab

See also