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 |