Delphi Database, Delphi Components from ComponentAce
Products Download Order Contact us
Field Data Types
Previous  Top  Next



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. Supported in CB6, and in Delphi 6 and higher only.
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


        © 2003 - 2017 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Oct 20, 2017