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.
