Item type properties
The following table lists the ODBC data types and the values of the item type properties to which they correspond when the type tree is generated.
| ODBC Data Type | Interpret as | Item Subclass, Presentation | Length |
|---|---|---|---|
| SQL_VARCHAR | Character | Text | * |
| SQL_CHAR | Character | Text | * |
| SQL_DECIMAL | Character | Number, Decimal | * |
| SQL_NUMERIC | Character | Number, Decimal | * |
| SQL_SMALLINT | Character | Number, Integer | 6 |
| SQL_INTEGER | Character | Number, Integer | 11 |
| SQL_REAL | Binary | Number, Float | 4 |
| SQL_FLOAT | Binary | Number, Float | 8 |
| SQL_DOUBLE | Binary | Number, Float | 8 |
| SQL_LONGVARCHAR | Character | Text | * |
| SQL_BIT | Character | Number, Integer | * |
| SQL_TINYINT | Character | Number, Integer | 4 |
| SQL_BIGINT | Character | Number, Integer | 20 |
| SQL_BINARY | Binary | Text | * |
| SQL_VARBINARY | Binary | Text | * |
| SQL_LONGVARBINARY | Binary | Text | * |
| SQL_DATE | Character | Date & Time | * |
| SQL_TIME | Character | Date & Time | * |
| SQL_TIMESTAMP | Character | Date & Time | * |
| SQL_INTERVAL_HOUR | Character | Text | * |
| SQL_INTERVAL_MINUTE | Character | Text | * |
| SQL_INTERVAL_SECOND | Character | Text | * |
| SQL_INTERVAL_YEAR_TO_MONTH | Character | Text | * |
| SQL_INTERVAL_DAY_TO_HOUR | Character | Text | * |
| SQL_INTERVAL_DAY_TO_MINUTE | Character | Text | * |
| SQL_INTERVAL_DAY_TO_SECOND | Character | Text | * |
| SQL_INTERVAL_HOUR_TO_MINUTE | Character | Text | * |
| SQL_INTERVAL_HOUR_TO_SECOND | Character | Text | * |
| SQL_INTERVAL_MINUTE_TO_SECOND | Character | Text | * |
* The DBMS dictates the length of this type.