If your application specifies EDS_SQL_DEFAULT for the ETYPE argument in EDSBindCol, EDSGetData, or EDSSetParam, EDS assumes that the ESL data type of the specified storage location corresponds to the SQL data type of the column or parameter to which the location is bound. For each SQL data type, the following table shows the corresponding, or “default,” ESL data type.
SQL Data Type |
Corresponding ESL Data Type |
SQL_CHAR |
EDS_STRING |
SQL_VARCHAR |
EDS_STRING |
SQL_LONGVARCHAR |
EDS_STRING |
SQL_DECIMAL |
EDS_FLOAT |
SQL_NUMERIC |
EDS_FLOAT |
SQL_BIT |
EDS_INT |
SQL_TINYINT |
EDS_INT |
SQL_SMALLINT |
EDS_INT |
SQL_INTEGER |
EDS_INT |
SQL_BIGINT |
EDS_STRING |
SQL_REAL |
EDS_FLOAT |
SQL_FLOAT |
EDS_FLOAT |
SQL_DOUBLE |
EDS_FLOAT |
SQL_BINARY |
EDS_STRING |
SQL_VARBINARY |
EDS_STRING |
SQL_LONGVARBINARY |
EDS_STRING |
SQL_DATE |
EDS_STRING |
SQL_TIME |
EDS_STRING |
SQL_TIMESTAMP |
EDS_STRING |
