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
|
