Specifies the maximum size of columns of the String data type that the driver describes through result set descriptions and catalog functions.
Valid Values
A positive integer from 255 to x
where:
x
is maximum size of the SQL_VARCHAR data type.
Notes
Microsoft Access and Tableau users must configure this option to the following values:
For Microsoft Access, specify a value of 255.
For Tableau, specify a value from 255 to 4000 that suits your environment.
The value specified for the String Describe Type connection option determines whether the String data type maps to the SQL_WVARCHAR or SQL_WLONGVARCHAR ODBC data types.
Max String Size replaces the Max Varchar Size connection option.
Microsoft Access and Tableau users must configure this option to the following values: