SQLGetTypeinfo returns information about a specified ODBC data type. It may also return information about SQL_ALL_TYPES, in which case it returns information about all the ODBC data types.
The LOB related information depends on whether or not LOB Support is available. LOB Support is available when the database supports the LOB feature and the UseNativeLOBSupport option has not been set to No.
If LOB Support is available, when SQLGetTypeInfo is called with SQL_ALL_TYPES, SQL_ALL_TYPES will include information about the SQL_LONGVARBINARY or SQL_LONGVARCHAR data types.
If LOB Support is not available, then SQL_ALL_TYPES will not include information about the SQL_LONGVARBINARY or SQL_LONGVARCHAR data types.
When SQLGetTypeInfo is called with either SQL_LONGVARBINARY or SQL_LONGVARCHAR, it will return information about these data types irrespective of whether Native LOB Support is available or not. See the table that follows.
| LOB Support Available | SQL_ALL_TYPES includes LONG data types | SQL_LONGVARBINARY maps to | SQL_LONGVARCHAR maps to |
|---|---|---|---|
| Yes | Yes | BLOB | CLOB |
| No | No | VARBYTE(3200) | LONG VARCHAR |