17.20 - SQLGetTypeInfo - 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

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