Online Documentation for Advanced Data Export for RAD Studio VCL

Oracle


Delphi type

SQL data type

ftWideString

<2000 chars - NVARCHAR2

>2000 chars - BLOB

ftSmallint, ftInteger, ftWord, ftAutoInc, ftLargeint, ftFloat, ftCurrency, ftBCD, ftFMTBcd

NUMBER

ftBoolean

CHAR(1)

ftDate

DATE

ftTime, ftDateTime, ftTimeStamp

DATE

ftDateTime, ftTimeStamp

TIMESTAMP

ftParadoxOle, ftArray, ftOraBlob, ftOraClob, ftDBaseOle, ftGraphic, ftBytes, ftVarBytes, ftBlob, ftTypedBinary, ftFmtMemo

BLOB

ftMemo, ftVariant

CLOB

ftMemo, ftVariant

CLOB

ftLargeint

BIGINT

 

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