Re: [sqlite] Unwanted CLI CR-LF to LF conversion

2010-03-29 Thread Roger Binns
-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

[sqlite] Unwanted CLI CR-LF to LF conversion

2010-03-28 Thread Tomáš Szépe
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