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