On Fri, 16 Jan 2015 10:38:54 -0800
Dave Dyer <[email protected]> wrote:
> [$] sqlite3 po.sqlite .dump | sqlite3 po2.sqlite
> Error: incomplete SQL: INSERT INTO "imageblob" VALUES(1,'G:\share
Perhaps try -echo, to display the incomplete SQL?
I'm skeptical of the notion that cmd.exe is diddling with your data en
route to the pipe. I can't think of a time Windows munged my data in
that particular way despite more years using that lousy tool than I
care to remember. Quotes and escapes, sure, don't get me started.
Shot in the dark: maybe a string is being continued by ending the
line with a backslash. If the output handle is opened as text with
fopen, the sequence would be
5c 0d 0a
which the escape-reader wouldn't recognize, expecting only
5c 0a
leading to a noncontinued, incomplete line.
But that doesn't explain the difference between redirecting to a file
and redirecting to a pipe.
HTH.
--jkl
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
