Fieldmapping between Sqlite and Delphi (Pascal) – Comparison FireDAC and ZEOS

May a user has to change the database connector of a sqlite3 database within a delphi application between FireDAC and Zeos. If so, you have to aware that your database table fields are mapped to the database fieldtypes you expect.

Unfortunately the name to type mapping between zeos and FireDAC is not similar. See the table to analyze the mapping. To solve this in a migration you either have to change the database fieldtypes or the fieldtypes within your delphi application.

Link to pdf file of this table