SQLColAttribute returns information about columns in a result set. The fields listed in this table contain important LOB-specific information.
| Field Identifier | Value |
|---|---|
| SQL_DESC_DISPLAY_SIZE | CLOB = 2097088000 BLOB = 4194176000 |
| SQL_DESC_NULLABLE | “No” It is set to No because of the restriction on the use of LOB NULL values in SQLPutData.
|
| SQL_DESC_SEARCHABLE | SQL_FALSE BLOB and CLOB columns cannot be used in ORDER BY and in a WHERE clause.
|
| SQL_DESC_TYPE | SQL_LONGVARBINARY for BLOB columns SQL_LONGVARCHAR for CLOB columns |