skip to main content
Part 4: The Connect XE Drivers : The Driver for Apache Hive : Connection Option Descriptions : String Describe Type
  
String Describe Type
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 | -1 | 12
Behavior
If set to -10 -(SQL_WLONGVARCHAR), all strings 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
12 - SQL_VARCHAR
GUI Tab
Advanced tab