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 <[email protected]>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
