Request 'Integer' column mapping to TLargeintField in SQLite

Freature requests from users for ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist, mdaems

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

Request 'Integer' column mapping to TLargeintField in SQLite

Postby Faceker » 24.10.2008, 15:34

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:

Postby mdaems » 01.11.2008, 15:56

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


Return to “Feature Requests”

Who is online

Users browsing this forum: No registered users and 1 guest