Online Documentation for Advanced Data Export for RAD Studio VCL
MS SQL Server
|
Delphi type |
SQL data type |
|
ftSmallint |
SMALLINT |
|
ftBoolean |
CHAR(1) |
|
ftFloat |
FLOAT |
|
ftCurrency, ftBCD, ftFMTBcd |
NUMERIC(15,2) |
|
ftDate, ftTime, ftDateTime |
DATETIME |
|
ftTime |
TIME |
|
ftDateTime, ftTimeStamp |
TIMESTAMP |
|
ftOraClob, ftMemo, ftFmtMemo |
TEXT |
|
ftOraBlob, ftBlob, ftGraphic |
IMAGE |
|
ftGuid |
NCHAR |
|
ftWideString |
<8000 chars - NVARCHAR >8000 chars - NTEXT |
|
ftBytes |
BINARY |
|
ftVarBytes |
VARBINARY |
|
ftTimeStamp |
TIMESTAMP |
|
ftVariant |
SQL_VARIANT |
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 TEXT.
