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
When returning result set metadata for Varchar columns, the Spark Thrift server reports the column type as (12) STRING and the precision as 2147483647. This issue can cause the settings of the following connection options to produce unexpected results: Max String Size, Min Long Varchar Size, String Describe Type, and Varchar Threshold. For the latest information about this issue, refer to the Apache JIRA SPARK-5918 issue Web page: https://issues.apache.org/jira/browse/SPARK-5918.
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.
When returning result set metadata for Varchar columns, the Spark Thrift server reports the column type as (12) STRING and the precision as 2147483647. This issue can cause the settings of the following connection options to produce unexpected results: Max String Size, Min Long Varchar Size, String Describe Type, and Varchar Threshold. For the latest information about this issue, refer to the Apache JIRA SPARK-5918 issue Web page: https://issues.apache.org/jira/browse/SPARK-5918.