Request 'Integer' column mapping to TLargeintField in SQLite

Freature requests from users for ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist, mdaems

Post Reply
Faceker
Fresh Boarder
Fresh Boarder
Posts: 12
Joined: 04.10.2008, 14:56

Request 'Integer' column mapping to TLargeintField in SQLite

Post by Faceker »

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
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

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
Image
Post Reply