Hi, cat << EOF| sqlite3 x.sqlite3 create table foo(bar text); insert into foo values('
baz x'); EOF The literal written as a C string is "\r\r\rbaz\r\nx". However, the string actually stored turns out to be "\r\r\rbaz\nx". $ echo .dump| sqlite3 x.sqlite3 PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE foo(bar text); INSERT INTO "foo" VALUES(' baz x'); COMMIT; Happens even with CLI ".read" command. I believe this to be a bug. Linux/i686, sqlite-3.6.23. Best regards, -- Tomáš Szépe <sz...@pinerecords.com> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users