Item type properties
The following table lists the Microsoft SQL Server data types and the values of the item type properties to which they correspond when the type tree is generated.
| Microsoft SQL Server Data Type | Interpret as | Item Subclass, Presentation | Length |
|---|---|---|---|
| BINARY | Binary | Text | * |
| CHAR | Character | Text | * |
| DATETIME | Character | Date & Time | 23 |
| DECIMAL(n) 1 | Character | Number, Integer | * |
| DECIMAL(n,m)2 | Character | Number, Decimal | * |
| FLOAT | Binary | Number, Float | 8 |
| IMAGE | Binary | Text | * |
| INT | Character | Number, Integer | 11 |
| MONEY | Character | Number, Decimal | 17 |
| NUMERIC(n) 1 | Character | Number, Integer | * |
| NUMERIC(n,m) 2 | Character | Number, Decimal | * |
| REAL | Binary | Number, Float | 4 |
| SMALLDATETIME | Character | Date & Time | 19 |
| SMALLINT | Character | Number, Integer | 6 |
| SMALLMONEY | Character | Number, Decimal | 17 |
| TEXT | Character | Text | * |
| TIMESTAMP | Binary | Text | 8 |
| TINYINT | Character | Number, Integer | 4 |
| VARBINARY | Binary | Text | * |
| VARCHAR | Character | Text | * |
1 n > 1
2 n > 1, m > 0
* The DBMS dictates the length of this type.