Applications that migrate to an ODBC Driver with Native LOB Support may behave differently than before the migration. This might be related to the use of LOBs.
There can be two reasons for the difference in behavior:
- The application relies on the ODBC feature that allows an application to query for all available types and uses that information to generate SQL
- The application uses the ODBC types SQL_LONGVARBINARY and SQL_LONGVARCHAR
Applications that query for all types will now receive information about two data types (BLOB and CLOB) which can cause problems in some cases. See SQLGetTypeInfo.
Applications that use SQL_LONGVARBINARY and SQL_LONGVARCHAR may behave differently since these types are now mapped differently.
If application behavior has changed, consider disabling the Native LOB functionality by setting UseNativeLOBSupport=No.
The option to set Native LOB Support is deprecated. For more information, see Deprecated SQL Transformations