Why is it a problem using an Int64 with an Sqlite database?

[domus 2]

While the documentation site is down, would anyone know why it's a problem using an Int64 with an Sqlite database? Int64 values written to Sqlite Integer fields seem to be problematic (truncated to 32-bits). Manually changing all field properties to .AsLargeint, on the other hand, throws a "type mismatch" exception at application startup. All Sqlite integer fields are supposed to support 64-bit values.

 

(don't bother, solved by manually using BIGINT in creation of table)

Edited January 16, 2024 by Lars Fosdal
Changed topic title

[stijnsanders 38]

What are you using to use SQLite from a Delphi project? I'm using a really thing wrapper around sqlite3.dll and haven't found any trouble with integer types. (Also, good to know is that SQLite handles column type a bit different.)

[domus 2]

3 hours ago, stijnsanders said:

What are you using to use SQLite from a Delphi project? I'm using a really thing wrapper around sqlite3.dll and haven't found any trouble with integer types. (Also, good to know is that SQLite handles column type a bit different.)

Just FireDAC, in Windows. But problem was solved in the mean time.

 

Cheers!

Dom