SQL_VCLDB数据类型
VCL SQL ftAutoInc AutoInc, AutoIncInteger
AutoIncShortint
AutoIncSmallint
AutoIncLargeint
AutoIncByte
AutoIncWord
AutoIncCardinal ftSmallint Shortint, SignedInt8
Smallint, SignedInt16 ftInteger Integer, SignedInt32 ftLargeint Largeint, Int64, SignedInt64
Cardinal, UnsignedInt32 ftCurrency Currency, Money ftBCD
ftWord Byte, UnsignedInt8
Word, UnsignedInt16 ftBoolean Boolean, Logical, Bool, Bit ftFloat Single
Float, Double
Extended ftBytes Bytes ftVarBytes VarBytes ftString Varchar, Varchar2, String ftFixedChar Char, FixedChar ftWideString WideChar, FixedWideChar
WideVarchar, WideString
ftDate Date ftTime Time ftDateTime DateTime ftTimeStamp TimeStamp ftBlob Blob ftGraphic Graphic ftMemo Memo, Clob
WideMemo, WideClob ftFmtMemo FormattedMemo, FmtMemo ftParadoxOle
ftDBaseOle
ftTypedBinary
ftCursor
ftADT
ftArray
ftReference ftDataSet ftOraBlob ftOraClob ftVariant ftInterface ftIDispatch ftGuid ftFMTBcd ftUnknown
Description
Auto-incrementing 32-bit integer counter field
Auto-incrementing 8-bit integer counter field
Auto-incrementing 16-bit integer counter field
Auto-incrementing 64-bit integer counter field
Auto-incrementing byte counter field
Auto-incrementing 16-bit unsigned integer counter field
Auto-incrementing 32-bit unsigned integer counter field
8-bit integer field
16-bit integer field
32-bit integer field
Large integer field
Money field
Binary-Coded Decimal field that can be converted to Currency type without a loss of precis 8-bit unsigned integer field
16-bit unsigned integer field
Boolean field
Floating-point numeric field
Floating-point numeric field
Floating-point numeric field
Fixed number of bytes (binary storage)
Variable number of bytes (binary storage)
Character or string field
Fixed character field
Wide string field
Date field
Time field
Date and time field
Date and time field accessed through dbExpress
Binary Large OBject field
Bitmap field
Text memo field
Unicode text memo field
Formatted text memo field
Paradox OLE field
dBASE OLE field
Typed binary field
Output cursor from an Oracle stored procedure (TParam only)
Abstract Data Type field
Array field
REF field
DataSet field
BLOB fields in Oracle 8 tables
CLOB fields in Oracle 8 tables
Data of unknown or undetermined type
References to interfaces (IUnknown)
References to IDispatch interfaces
globally unique identifier (GUID) values
Binary-Coded Decimal field that is too large for ftBCD. Unknown or undetermined
oss of precision.