Flexible data type handling

AnyDAC supports most data types supported by current DBMS’s, including different kinds of BLOB data, Unicode data, high precision numbers, etc. Also, programmer has complete control on the mapping of row column data types into dataset field types and backwards.

You can map almost any data type to another one using DataFormat options. That allows to create compatible data mapping schemas for different DBMS's and DAC's. Following example shows, how to set up mapping rules (MapRules) to make compatibility of data types between Oracle AnyDAC connection and BDE one.

AnyDAC supports Unicode for all supported DBMS’s, as for short text data types, as for long text data types and for columns and parameters. The library supports all range of different BLOB data types including Oracle BLOB, CLOB, BFILE and long Unicode text. Also, library supports high precision numbers - BCD and some other data types.