String Describe Type
- Last Updated: October 3, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
Attribute
StringDescribeType (SDT)
Purpose
Specifies whether all string columns are described as SQL_VARCHAR. This connection option affects SQL_Columns, SQLDescribeCol, SQLColAttributes, etc. It does not affect SQLGetTypeInfo.
Valid Values
-10 | -9
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.
Default
-9 - SQL_WVARCHAR