>>> -----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.
