SQL_INFX_ATTR_DEFAULT_UDT_FETCH_TYPE

Applications can set the SQL_INFX_ATTR_DEFAULT_UDT_FETCH_TYPE attribute to SQL_C_CHAR or SQL_C_BINARY to set the default fetch type for UDTs.

The default value of this attribute is set depending on the following conditions:
  • If the DSN setting for Report Standard ODBC Types is ON, the value of DefaultUDTFetchType is set to SQL_C_CHAR.
  • If the DSN setting for Report Standard ODBC Types is OFF, the value of DefaultUDTFetchType is set to SQL_C_BINARY.
  • If a user has set a registry key, the value of DefaultUDTFetchType is set to the value in the registry provided Report Standard ODBC Types is not set.

An application can change the value of this attribute by using SQLSetConnectAttr and SQLSetStmtAttr (SQLSetConnectOption and SQLSetStmtOption in ODBC 2.x). Applications can retrieve the values set by using SQLGetConnectAttr and SQLGetStmtAttr (SQLGetConnectOption and SQLGetStmtOption in ODBC 2.x).

Setting the Report Standard ODBC Types to ON always overrides DefaultUDTFetchType to SQL_C_CHAR.