TFieldType enumeration

In unit DB

Field data type description.

Declaration

pascal

TFieldType = (ftUnknown,ftString,ftSmallint,ftInteger,ftWord,ftBoolean,
 ftFloat,ftCurrency,ftBCD,ftDate,ftTime,ftDateTime,ftBytes,
 ftVarBytes,ftAutoInc,ftBlob,ftMemo,ftGraphic,ftFmtMemo,
 ftParadoxOle,ftDBaseOle,ftTypedBinary,ftCursor,
 ftFixedChar,ftWideString,ftLargeint,ftADT,ftArray,
 ftReference,ftDataSet,ftOraBlob,ftOraClob,ftVariant,
 ftInterface,ftIDispatch,ftGuid,ftTimeStamp,ftFMTBcd,
 ftFixedWideChar,ftWideMemo,ftOraTimeStamp,ftOraInterval,
 ftLongWord,ftShortint,ftByte,ftExtended,ftSingle)

Description

TFieldType indicates the type of a TField underlying data, in the DataType property.

Values

`ftUnknown`	Unknown data type.
`ftString`	String data value (ansistring).
`ftSmallint`	Small integer value(1 byte, signed).
`ftInteger`	Regular integer value (4 bytes, signed).
`ftWord`	Word-sized value(2 bytes, unsigned).
`ftBoolean`	Boolean value.
`ftFloat`	Floating point value (double).
`ftCurrency`	Currency value (4 decimal points).
`ftBCD`	Binary Coded Decimal value (DECIMAL and NUMERIC SQL types).
`ftDate`	Date value.
`ftTime`	Time value.
`ftDateTime`	Date/Time (timestamp) value.
`ftBytes`	Array of bytes value, fixed size (unytped).
`ftVarBytes`	Array of bytes value, variable size (untyped).
`ftAutoInc`	Auto-increment integer value (4 bytes).
`ftBlob`	Binary data value (no type, no size).
`ftMemo`	Binary text data (no size).
`ftGraphic`	Graphical data value (no size).
`ftFmtMemo`	Formatted memo data value (no size).
`ftParadoxOle`	Paradox OLE field data (no size).
`ftDBaseOle`	Paradox OLE field data.
`ftTypedBinary`	Binary typed data (no size).
`ftCursor`	Cursor data value (no size).
`ftFixedChar`	Fixed character array (string).
`ftWideString`	Widestring (2 bytes per character).
`ftLargeint`	Large integer value (8-byte).
`ftADT`	ADT value.
`ftArray`	Array data.
`ftReference`	Reference data.
`ftDataSet`	Dataset data (blob).
`ftOraBlob`	Oracle BLOB data.
`ftOraClob`	Oracle CLOB data.
`ftVariant`	Variant data value.
`ftInterface`	interface data value.
`ftIDispatch`	Dispatch data value.
`ftGuid`	GUID data value.
`ftTimeStamp`	Timestamp data value.
`ftFMTBcd`	Formatted BCD (Binary Coded Decimal) value.
`ftFixedWideChar`	Fixed wide character date (2 bytes per character).
`ftWideMemo`	Widestring memo data.
`ftOraTimeStamp`	Oracle time stamp field type.
`ftOraInterval`	Oracle interval field type.
`ftLongWord`	Longword (cardinal) field type.
`ftShortint`	Shortint field type.
`ftByte`	Byte field type.
`ftExtended`	Extended field type.
`ftSingle`

An experiment, built from development snapshots. Not the official Free Pascal or Lazarus documentation.