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
Request 'Integer' column mapping to TLargeintField in SQLite
Moderators: gto, cipto_kh, EgonHugeist, mdaems
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
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
Have you tried switching the mapping in ConvertSQLiteTypeToSQLType (ZDbcSqliteUtils.pas) ?
Mark