skip to main content
Connection Properties Reference : Min Long Varchar Size
 

Try DataDirect Cloud Now

Min Long Varchar Size

Attribute

MinLongVarcharSize (MINLVS)

Purpose

Specifies the minimum count of characters the driver reports for columns mapped as SQL_LONGVARCHAR. If the size of a SQL_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_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.

Valid values

A positive integer from 1 to x
where:
x
is the minimum size in characters the driver will report for columns mapped to the SQL_LONGVARCHAR type.

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 column size reported for SQL_LONGVARCHAR columns.

GUI tab

Advanced tab