SQL data type
|
Description
|
Corresponding TFieldType
|
Char, FixedChar
|
Fixed character field
|
ftFixedChar
|
Varchar, Varchar2, String
|
Character or variable length string field
|
ftString
|
WideChar, FixedWideChar
|
Fixed wide character field
|
ftWideString
|
WideVarchar, WideString
|
Wide character or variable length wide string field
|
ftWideString
|
Shortint, SignedInt8
|
8-bit integer field
|
ftSmallint
|
Smallint, SignedInt16
|
16-bit integer field
|
ftSmallint
|
Integer, SignedInt32
|
32-bit integer field
|
ftInteger
|
Largeint, Int64, SignedInt64
|
64-bit integer field
|
ftLargeint
|
Byte, UnsignedInt8
|
Byte field
|
ftWord
|
Word, UnsignedInt16
|
16-bit unsigned integer field
|
ftWord
|
Cardinal, UnsignedInt32
|
32-bit unsigned integer field
|
ftLargeint
|
AutoInc, AutoIncInteger
|
Auto-incrementing 32-bit integer counter field
|
ftAutoinc
|
AutoIncShortint
|
Auto-incrementing 8-bit integer counter field
|
ftAutoinc
|
AutoIncSmallint
|
Auto-incrementing 16-bit integer counter field
|
ftAutoinc
|
AutoIncLargeint
|
Auto-incrementing 64-bit integer counter field
|
ftAutoinc
|
AutoIncByte
|
Auto-incrementing byte counter field
|
ftAutoinc
|
AutoIncWord
|
Auto-incrementing 16-bit unsigned integer counter field
|
ftAutoinc
|
AutoIncCardinal
|
Auto-incrementing 32-bit unsigned integer counter field
|
ftAutoinc
|
Single
|
Single floating-point numeric field
|
ftFloat
|
Float, Double
|
Double floating-point numeric field
|
ftFloat
|
Extended
|
Extended floating-point numeric field
|
ftFloat
|
Boolean, Logical, Bool, Bit
|
Boolean field
|
ftBoolean
|
Currency, Money
|
Money field
|
ftCurrency
|
Date
|
Date field
|
ftDate
|
Time
|
Time field
|
ftTime
|
DateTime
|
Date and time field
|
ftDateTime
|
TimeStamp
|
Date and time field accessed through dbExpress
|
ftTimeStamp
|
Bytes
|
Fixed number of bytes (binary storage)
|
ftBytes
|
VarBytes
|
Variable number of bytes (binary storage)
|
ftVarBytes
|
Blob
|
Binary Large OBject field
|
ftBlob
|
Graphic
|
Bitmap field
|
ftGraphic
|
Memo, Clob
|
Text memo field
|
ftMemo
|
FormattedMemo, FmtMemo
|
Formatted text memo field
|
ftFmtMemo
|
WideMemo, WideClob
|
Unicode text memo field
|
ftMemo
|