Max String Size
- Last Updated: March 2, 2022
- 1 minute read
- DataDirect Connectors
- ODBC
- Apache Hive 8.0
- Documentation
Attribute
MaxStringSize (MSS)
Purpose
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 columns defined as the String 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.
Default
2147483647