-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 string. 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 executed. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkuw4x4ACgkQmOOfHg372QT6HACfR5LnemoEQvmWV3lYu+K//pmh wB8An0oB8d6LPP90TLZkrhlwPVCaEJma =oToI -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users