Online Documentation for Advanced Data Export for RAD Studio VCL
Postgresql
|
Delphi type |
SQL data type |
|
ftSmallint |
SMALLINT |
|
ftInteger, ftWord, ftAutoInc, ftReference |
INTEGER |
|
ftLargeint |
BIGINT |
|
ftBoolean |
BOOLEAN |
|
ftFloat |
DOUBLE PRECISION |
|
ftCurrency, ftBCD, ftFMTBcd |
NUMERIC(20,4) |
|
ftDate |
DATE |
|
ftTime |
TIME |
|
ftDateTime, ftTimeStamp |
TIMESTAMP |
|
ftParadoxOle, ftDBaseOle, ftTypedBinary, ftCursor, ftBytes, ftVarBytes,ftBlob, ftArray, ftOraBlob, ftDataSet |
BYTEA |
|
ftWideString, ftMemo, ftFmtMemo, ftGraphic, ftADT, ftOraClob, ftVariant, ftInterface, ftIDispatch, ftGuid |
TEXT |
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.
