17.20 - Migration Issues - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

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.