"ryan bel brillo" <[EMAIL PROTECTED]> wrote:
>
> On linux, I got an sqlite database version 3.3.2 while on windows its
> sqlite database version 3.2.1, I'll upgrade my sqlite database to
> version 3.3.x
>
> So that's explain why sqlite database created on windows can be read
> just fine in linux.
>
The file format is backwards but not forwards compatible.
You can get version 3.3.4 to generate the older file format
by doing:
PRAGMA legacy_file_format=1;
You can also recompile with:
-DSQLITE_DEFAULT_FILE_FORMAT=1
--
D. Richard Hipp <[EMAIL PROTECTED]>
