String Describe Type
- Last Updated: September 5, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Apache Hive 8.0
- Documentation
Attribute
StringDescribeType (SDT)
Purpose
Specifies the data type used to describe String columns. This connection option affects functions that return column-related data, such as SQLColumns, SQLDescribeCol, and SQLColAttributes. It does not affect SQLGetTypeInfo.
Valid Values
-10 | -9 | -1 | 12
Behavior
If set to -10 (SQL_WLONGVARCHAR), all String columns are described as SQL_WLONGVARCHAR.
If set to -9 (SQL_WVARCHAR), all String columns are described as SQL_WVARCHAR.
If set to -1 (SQL_LONGVARCHAR), all String columns are described as SQL_LONGVARCHAR.
If set to 12 (SQL_VARCHAR), all String columns are described as SQL_VARCHAR.
Default
-9 (SQL_WVARCHAR)