Re: [sqlite] Database created in linux cant be read in windows
"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]>
RE: [sqlite] Database created in linux cant be read in windows
>>> -Original Message- >>> From: Christian Smith [mailto:[EMAIL PROTECTED] >>> Sent: Tuesday, March 14, 2006 4:06 AM >>> To: sqlite-users@sqlite.org >>> Subject: RE: [sqlite] Database created in linux cant be read in windows >>> >>> On Wed, 15 Mar 2006, ryan bel brillo wrote: >>> >>> > Im using a software ipswitch WS_FTP to transfer the file from linux >>> to >>> >windows. Im not sure before if I configured it to binary transfer but >>> I >>> >tried it again and make sure to configure it and set it to binary >>> >transfer, still im getting the same result. >>> > >>> > Currently, Im trying to create the database in windows then use the >>> >created database as my base db in linux. Then I'll just have to update >>> >the base db in linux using the different sql statement in postgresql >>> and >>> >transfer it back to windows if the base db can still be read with the >>> >updates. >>> > >>> > On trying to read the file on sqlite3 command line program in >>> >>> windows; >>> >I'll try it later. >>> >>> >>> What version of SQLite are you using on Windows? 3.x where x<3 has >>> problems reading databases created with 3.3 and above due to a small >>> change in file format. Make sure you have 3.3.x on Windows as well. >>> >>> The database itself should otherwise be compatible. >>> >>> Christian >>> >>> -- >>> /"\ >>> \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL >>> X - AGAINST MS ATTACHMENTS >>> / \ >>> 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.
Re: [sqlite] Database created in linux cant be read in windows
> Im using a software ipswitch WS_FTP to transfer the file from linux to > windows. Im not sure before if I configured it to binary transfer but I > tried it again and make sure to configure it and set it to binary > transfer, still im getting the same result. Try setting the transfer mode to binary and seeing if that fixes it.
RE: [sqlite] Database created in linux cant be read in windows
On Wed, 15 Mar 2006, ryan bel brillo wrote: > Im using a software ipswitch WS_FTP to transfer the file from linux to >windows. Im not sure before if I configured it to binary transfer but I >tried it again and make sure to configure it and set it to binary >transfer, still im getting the same result. > > Currently, Im trying to create the database in windows then use the >created database as my base db in linux. Then I'll just have to update >the base db in linux using the different sql statement in postgresql and >transfer it back to windows if the base db can still be read with the >updates. > > On trying to read the file on sqlite3 command line program in windows; >I'll try it later. What version of SQLite are you using on Windows? 3.x where x<3 has problems reading databases created with 3.3 and above due to a small change in file format. Make sure you have 3.3.x on Windows as well. The database itself should otherwise be compatible. Christian -- /"\ \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \
RE: [sqlite] Database created in linux cant be read in windows
Im using a software ipswitch WS_FTP to transfer the file from linux to windows. Im not sure before if I configured it to binary transfer but I tried it again and make sure to configure it and set it to binary transfer, still im getting the same result. Currently, Im trying to create the database in windows then use the created database as my base db in linux. Then I'll just have to update the base db in linux using the different sql statement in postgresql and transfer it back to windows if the base db can still be read with the updates. On trying to read the file on sqlite3 command line program in windows; I'll try it later. -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: Monday, March 13, 2006 6:10 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Database created in linux cant be read in windows ryan bel brillo wrote: > Is there a compatibility problem with database created in linux and > windows? I remember this problem on occurs on sqlite version 2.6.2 or > earlier.. Or is there a problem in the way I create the database? How are you getting the file from Linux to Windows? If you used FTP it's possible that you forgot to configure your FTP client for a binary transfer. In that case certain characters would have been added. If you didn't transfer the files via FTP then I really can't say, and would suspect a corrupt file. One thing you might try though is reading the file on Windows with the sqlite3 command line program. That would be the authoritative source. Clay Dowling -- CeaMuS http://www.ceamus.com Simple Content Management
Re: [sqlite] Database created in linux cant be read in windows
ryan bel brillo wrote: > Is there a compatibility problem with database created in linux and > windows? I remember this problem on occurs on sqlite version 2.6.2 or > earlier.. Or is there a problem in the way I create the database? How are you getting the file from Linux to Windows? If you used FTP it's possible that you forgot to configure your FTP client for a binary transfer. In that case certain characters would have been added. If you didn't transfer the files via FTP then I really can't say, and would suspect a corrupt file. One thing you might try though is reading the file on Windows with the sqlite3 command line program. That would be the authoritative source. Clay Dowling -- CeaMuS http://www.ceamus.com Simple Content Management