Online Documentation for Advanced Data Export for RAD Studio VCL

MY SQL


Delphi type

SQL data type

ftSmallint

SMALLINT

ftBoolean

BOOLEAN

ftInteger, ftWord, ftAutoInc

INTEGER

ftLargeint

BIGINT

ftFloat

DOUBLE

ftCurrency, ftBCD, ftFMTBcd

FLOAT(15,2)

ftDate

DATE

ftTime

TIME

ftDateTime, ftTimeStamp

DATETIME

ftBlob, ftMemo, ftGraphic, ftFmtMemo, ftParadoxOle, ftDBaseOle, ftOraBlob, ftOraClob, ftVariant

LONGBLOB

ftMemo, ftVariant

CLOB

ftLargeint

BIGINT

 

For the rest of types the size of a field is checked. If the field size is less than 2048 chars then it is converted into VARCHAR. Otherwise, into TEXT.