Re: [sqlite] Export Of BLOB Data

2013-04-26 Thread Clemens Ladisch
Nigel Verity wrote: > I am on Linux, but need to export the data to somebody on Windows > running MS Access 2010. > > Can anybody advise on how to handle the export of the BLOB data? AFAIK Access does not have blob literals. So the best way would be to copy the SQLite file to the Windows PC,

[sqlite] Export Of BLOB Data

2013-04-26 Thread Nigel Verity
Hi I have a table with a record definition broadly as follows: ID (Integer Primary Key) Field1 (Text) Field2 (Text) Field3 (BLOB) The BLOB field contains document scans in JPG and PDF format, and some source documents in ODT and DOC formats. I am on Linux, but need to export the data to