I have been successfully using SQLite on a 32-bit embedded system for some time without any problems - you can add -DSQLITE_INT64_TYPE=long to the compile line, no need to hack the source. The only issue I have seen is that it is not possible to use -DSQLITE_DEBUG as it enables some assert() calls that will always fail on a 32-bit system. This makes debugging SQLite issues rather difficult, but does not seem to cause any serious problems.
Cheers, Dave. -----Original Message----- From: yamada [mailto:rafael.yam...@gmail.com] Sent: Thursday, March 11, 2010 8:59 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Sqlite without 64-bit integers? Hi, I am having the same problem here. Did someone tested the solution gave by mattias? Are there any problems? Mattias Ohlsson-3 wrote: > > I'm trying to use the SQLite database in an embedded system that does not > have 64-bit integers, i.e. long long, which is used in SQLite. I've > managed > to compile by definining the 64-bit types to 32-bit types: > > typedef long int sqlite_int64; > #define UINT64_TYPE unsigned long int > > I've also run some simple tests and it seems to work. However, I'm a bit > worried that this might lead me into problems down the road. Has anyone > tried to do this before? What kind of problems might I run into? > -- View this message in context: http://old.nabble.com/Sqlite-without-64-bit-integers--tp2337711p27866285 .html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users