Table 20. SQL symbolic and default data types
| SQL Data Type | Symbolic SQL Data Type | Default Symbolic C Data Type |
|---|---|---|
| BLOB | SQL_BLOB | SQL_C_BINARY |
| CHAR | SQL_CHAR | SQL_C_CHAR |
| DATE | SQL_TYPE_DATE | SQL_C_TYPE_DATE |
| DECIMAL | SQL_DECIMAL | SQL_C_CHAR |
| INTEGER | SQL_INTEGER | SQL_C_LONG |
| SMALLINT | SQL_SMALLINT | SQL_C_SHORT |
| TIME | SQL_TYPE_TIME | SQL_C_TYPE_TIME |
| TIMESTAMP | SQL_TYPE_TIMESTAMP | SQL_C_TYPE_TIMESTAMP |
| VARCHAR | SQL_VARCHAR | SQL_C_CHAR |