On 12/28/2017 03:20 AM, petern wrote:
sqlite> load zipfile.sosqlite> SELECT * FROM zipfile('rows.zip'); name,mode,mtime,sz,data,method row1.txt,33204,1514396814,22,"text of file row1.txt ",0 row2.txt,33204,1514396416,22,"text of file row2.txt ",0 --Extra newline is introduced for some reason. --Added explicit newline to end of row1.txt, then got this: sqlite> SELECT * FROM zipfile('rows.zip'); name,mode,mtime,sz,data,method row1.txt,33204,1514397988,23,"text of file row1.txt ",0 row2.txt,33204,1514396416,22,"text of file row2.txt ",0 #testfile $ zip -0 rows.zip row1.txt row2.txt $ zipinfo rows.zip Archive: rows.zip Zip file size: 355 bytes, number of entries: 2 -rw-rw-r-- 3.0 unx 23 bx stor 17-Dec-27 11:55 row1.txt -rw-rw-r-- 3.0 unx 22 bx stor 17-Dec-27 09:40 row2.txt 2 files, 45 bytes uncompressed, 45 bytes compressed: 0.0%
What does this command return? xxd row2.txt Thanks, Dan. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
