Data types

The following table shows a list of data types used in this document, to identify database items. The Data Type format supports both Oracle and SQL Server databases. Refer to the description column for the database-specific type.

Table 3 Data Types
Data type	Description
Boolean	Bit
Character	Char or varchar For Character data types, the maximum number of characters for the column name is shown.
DateTime	Datetime or smalldatetime
Decimal number	Decimal
GUID	SQL Server. uniqueidentifier Oracle. RAW(16)
Float	Floating point numeric: SQL Server. float Oracle. binary, binary_float, binary_double
Integer	Int or tinyint
Long-binary	SQL Server: image Oracle. CLOB
Long-text	Text
Short-binary (formerly <system>)	SQL Server. binary Oracle. RAW(16)