EMS logo

Навигация по продуктам

Advanced Data Export VCL

Наш партнерский статус

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Advanced Data Export VCL

Он-лайн Документация

DB2


Delphi type

SQL data type

ftSmallint

INTEGER

ftBoolean

BOOLEAN

ftFloat

FLOAT

ftCurrency, ftBCD, ftFMTBcd

NUMERIC(24,4)

ftDate

DATE

ftTime

TIME

ftDateTime, ftTimeStamp

TIMESTAMP

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

BLOB

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.