Zeoslib Portal

In SQLite, Integer column is 64 bit integer value, and 'Integer' column is special (see http://www.sqlite.org/datatype3.html), so I suggest mapping 'Integer' column to TLargeintField:

tinyint - TWordField
smallint - TSmallintField
int - TIntegerField
Integer - TLargeintField
bigint - TLargeintField
other int - TIntegerField or TLargeintField

But... there's still another documentation page available : http://www.sqlite.org/datatypes.html which limits Integer to 32 bit values.

Have you tried switching the mapping in ConvertSQLiteTypeToSQLType (ZDbcSqliteUtils.pas) ?

Mark