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 |