Tomáš Szépe wrote:
> Happens even with CLI ".read" command.
> I believe this to be a bug.
You are supplying text to a text based program and finding that it
treats text as text :-) Note that on Unix end of line is LF and that is
exactly what is happening.
Your work around is to supply blobs where you can provide the exact
UTF-8 byte sequence you want and then use CAST to convert to or from a
Alternatively you can write your own shell to handle things exactly the
way you want. At the heart of the shell is a loop that processes
internal commands (.dump, .read etc) if the line starts with a dot, else
sqlite3_complete() is called until it returns true and then the SQL is
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org