Re: [sqlite] File format changed !!
On 2/28/06, Pavan Savoy <[EMAIL PROTECTED]> wrote: > I am trying to open a database created in SQLite 3.3.1 in SQlite 3.1.2 > and I get the following err when I try to see the sqlite_master table .. > > SQL error: unsupported file format > > > I suppose the file format has been changed over the versions, but the > reverse does work, i.e db created on 3.1.2 can be opened on 3.3.1. > > > > I just wanted some sort of document which suggests changes in file format > over the versions, " changes " page doesnt represent the full picture > though > > http://sqlite.org/formatchng.html > > > Thank you > -- Firman Wandayandi Never Dreamt Before: http://firman.dotgeek.org/ Wishlist: http://www.amazon.com/gp/registry/1AAN8NZBHW2W9
RE: [sqlite] File format changed !!
Hi! Just use select * from sqlite_master; -Original Message- From: Pavan Savoy [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 10:13 PM To: sqlite-users@sqlite.org Subject: [sqlite] File format changed !! I am trying to open a database created in SQLite 3.3.1 in SQlite 3.1.2 and I get the following err when I try to see the sqlite_master table .. SQL error: unsupported file format I suppose the file format has been changed over the versions, but the reverse does work, i.e db created on 3.1.2 can be opened on 3.3.1. I just wanted some sort of document which suggests changes in file format over the versions, " changes " page doesnt represent the full picture though Thank you
[sqlite] File format changed !!
I am trying to open a database created in SQLite 3.3.1 in SQlite 3.1.2 and I get the following err when I try to see the sqlite_master table .. SQL error: unsupported file format I suppose the file format has been changed over the versions, but the reverse does work, i.e db created on 3.1.2 can be opened on 3.3.1. I just wanted some sort of document which suggests changes in file format over the versions, " changes " page doesnt represent the full picture though Thank you