Re: [sqlite] Dan: zipfile.c FYI data column quirk

2017-12-27 Thread petern
Hi Dan. $ xxd row2.txt 000: 7465 7874 206f 6620 6669 6c65 2072 6f77 text of file row 010: 322e 7478 740a 2.txt. 0a. Normally dependable Gedit, used for such tinkering, is putting in that linefeed. From my regular IDE I also see it. Sorry for the possible false

Re: [sqlite] Dan: zipfile.c FYI data column quirk

2017-12-27 Thread Peter Da Silva
I don’t see what the problem is, do you not expect a newline at the end of the line in a file? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Dan: zipfile.c FYI data column quirk

2017-12-27 Thread Dan Kennedy
On 12/28/2017 03:20 AM, petern wrote: sqlite> load zipfile.so sqlite> 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.

Re: [sqlite] Dan: zipfile.c FYI data column quirk

2017-12-27 Thread Simon Slavin
On 27 Dec 2017, at 8:20pm, petern wrote: > --Added explicit newline to end of row1.txt How. What did you do ? Was it a NL or a CR ? Or done as Unicode ? Simon. ___ sqlite-users mailing list

[sqlite] Dan: zipfile.c FYI data column quirk

2017-12-27 Thread petern
sqlite> load zipfile.so sqlite> 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