SQLGetTypeInfo

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

The following table shows how Number data types are reflected in selected columns from the result set returned by SQLGetTypeInfo for SQL_DECIMAL and SQL_DOUBLE.

DATA_TYPE TYPE_NAME COLUMN_SIZE CREATE_PARAMS NUM_PREC_RADIX TDODBC_DATA_TYPE
SQL_DECIMAL DECIMAL 38 precision, scale 10 SQL_DECIMAL
SQL_DECIMAL NUMBER 38 precision, scale 10 SQL_TD_FIXED_NUMBER
SQL_DECIMAL NUMBER 38 Precision 10 SQL_TD_FIXED_NUMBER
SQL_DOUBLE FLOAT 15 Null 2 SQL_DOUBLE
SQL_DOUBLE NUMBER 15 Null 10 SQL_TD_FLOATING_NUMBER