SQL Data Type

Description

AUTOINC

Auto incremental 32-bit unsigned integer.

BLOB

Binary Large Object - variable length binary data

BYTES

Fixed length binary data

CURRENCY, MONEY

Money value.

DATE

Date value.

DATETIME

DateTime value.

EXTENDED

Extended floating point number.

FLOAT

Floating point number

FORMATTEDMEMO

Formatted memo - variable length string in RTF format

GRAPHIC

Binary data for storing pictures

GUID

16-byte GUID

INTEGER

32-bit signed integer

LARGEINT, INT64

64-bit signed integer

LOGICAL, BOOLEAN, BOOL, BIT

Boolean value

MEMO, CLOB

Variable length string in plain text format

SMALLINT

16-bit signed integer

STRING, CHAR, VARCHAR, VARCHAR2, FIXEDCHAR

Fixed length string (may be up to 65500 bytes or up to page size)

TIME

Time value

TIMESTAMP

Timestamp value

VARBYTES

Variable number of bytes (binary storage)

WIDEMEMO

Variable length Unicode string in plain text format

WIDESTRING, WIDECHAR, FIXEDWIDECHAR, WIDEVARCHAR

Fixed length Unicode string (may be up to 65500 bytes or up to page size)

WORD, UNSIGNEDINT16

16-bit unsigned integer