Field Data Types

<< Click to Display Table of Contents >>

Navigation:  Appendix >

Field Data Types

Previous pageReturn to chapter overviewNext page

 

Field data types supported by Absolute Database are listed below:

 

Data Type

TFieldType

AdvFieldType

SQL Data Type

Description

AutoInc

ftAutoinc

aftAutoinc

AUTOINC

Auto incremental 32-bit unsigned integer.

BLOB

ftBlob

aftBlob

BLOB

Binary Large Object - variable length binary data

Bytes ( length )

ftBytes

aftBytes

BYTES

Fixed length binary data

Currency

ftCurrency

aftCurrency

CURRENCY, MONEY

Money value.

Date

ftDate

aftDate

DATE

Date value.

DateTime

ftDateTime

aftDateTime

DATETIME

DateTime value.

Extended

ftExtended

aftExtended

EXTENDED

Extended floating point number.

Float

ftFloat

aftDouble

FLOAT

Floating point number

FmtMemo

ftFmtMemo

aftFormattedMemo

FORMATTEDMEMO

Formatted memo - variable length string in RTF format

Graphic

ftGraphic

aftGraphic

GRAPHIC

Binary data for storing pictures

GUID

ftGUID

aftGuid

GUID

16-byte GUID

Integer

ftInteger

aftInteger

INTEGER

32-bit signed integer

LargeInt

ftLargeInt

aftLargeInt

LARGEINT, INT64

64-bit signed integer

Logical

ftBoolean

aftBoolean

LOGICAL, BOOLEAN, BOOL, BIT

Boolean value

Memo

ftMemo

aftMemo

MEMO, CLOB

Variable length string in plain text format

SmallInt

ftSmallint

aftSmallint

SMALLINT

16-bit signed integer

String ( length )

ftString, ftFixedChar

aftString, aftChar

STRING, CHAR, VARCHAR, VARCHAR2, FIXEDCHAR

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

Time

ftTime

aftTime

TIME

Time value

TimeStamp

ftTimeStamp

aftTimeStamp

TIMESTAMP

Timestamp value.

VarBytes

ftVarBytes

aftVarBytes

VARBYTES

Variable number of bytes (binary storage)

WideMemo

ftBlob

aftWideMemo

WIDEMEMO

Variable length Unicode string in plain text format

WideString ( length )

ftWideString

aftWideString

WIDESTRING, WIDECHAR, FIXEDWIDECHAR, WIDEVARCHAR

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

Word

ftWord

aftWord

WORD, UNSIGNEDINT16

16-bit unsigned integer

__________________________
Absolute SQL Reference - 06 February 2021, Niels Knabe