SQL_INFX_ATTR_DEFAULT_UDT_FETCH

Home | Previous Page | Next Page Data Types > Reporting Standard ODBC Types >

SQL_INFX_ATTR_DEFAULT_UDT_FETCH_TYPE

Applications can set this 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 using SQLSetConnectAttr and SQLSetStmtAttr (SQLSetConnectOption and SQLSetStmtOption in ODBC 2.x). Applications can retrieve the values set using SQLGetConnectAttr and SQLGetStmtAttr (SQLGetConnectOption and SQLGetStmtOption in ODBC 2.x).

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