Subject | Field type mapping |
---|---|
Author | adem |
Post date | 2003-03-18T01:10:30Z |
Hi,
Delphi7 has 37 different TField datatypes (i.e. TFieldType)
(actually, if you count ftUnknown, it is 38).
I have done quite a bit of searching but have been unable to
find a comprehensive list of which TFieldType maps to which
FB/IB field type.
I have copied Delphi's field types here, I would appreciate
if someone could map them to FB, please.
While it is true that some of this could be handled through
domains, some are harder to do so (such as ftGuid, ftWideString
etc.)
Is it really a good thing that FB has such few field types
(no flames please, this is an authentic passenger opinion :-),
does anyone know if things are likely to change with FB2;
shouldn't a 'relational database for the new millenium' be
richer in this aspect too :-)
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
--
Cheers,
Adem
Delphi7 has 37 different TField datatypes (i.e. TFieldType)
(actually, if you count ftUnknown, it is 38).
I have done quite a bit of searching but have been unable to
find a comprehensive list of which TFieldType maps to which
FB/IB field type.
I have copied Delphi's field types here, I would appreciate
if someone could map them to FB, please.
While it is true that some of this could be handled through
domains, some are harder to do so (such as ftGuid, ftWideString
etc.)
Is it really a good thing that FB has such few field types
(no flames please, this is an authentic passenger opinion :-),
does anyone know if things are likely to change with FB2;
shouldn't a 'relational database for the new millenium' be
richer in this aspect too :-)
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
--
Cheers,
Adem