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.