In 16.10 and prior versions of the driver, for all column attribute information retrieved using SQLColAttribute, ODBC Driver for Teradata returns values that vary based on the data.
For all column types, SQL_DESC_DATETIME_INTERVAL_PRECISION = SQL_DESC_PRECISION.
For all column types except for NUMERIC and DECIMAL, SQL_DESC_PRECISION = SQL_DESC_LENGTH.
The following table lists additional column attributes returned by ODBC Driver for Teradata, by column type.
|Column Type||Column Attributes Returned by ODBC Driver for Teradata 16.20 or Later|
|BIGINT||Octet length is 20.|
|DATE||Display size is returned as a number of characters.|
|DOUBLE, FLOAT, or REAL||Display size is 24.|
|JSON||Octet length is SQL_DESC_LENGTH * character size.|
|TIME||Display size is returned as a number of characters.|
|TIMESTAMP||Display size is returned as a number of characters.|