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 |