[sqlite] new line now \r\n regardless the OS

Funny enough, apparently we all get \n in Windows now :-) ( and yes, \r\n in Linux, isn't this hilarious ) Somebody filed a bug about this and I've actually/eventually/finally patched my code doing lazy evaluation of whatever comes after a 'SELECT 1' in CSV mode so that I should be sure enough th

[sqlite] new line now \r\n regardless the OS

also relevant: https://tools.ietf.org/html/rfc2046#section-4.1.1 grabbed from: Encoding considerations: As per section 4.1.1. of RFC 2046 [3 ], this media type uses CRLF to denote line bre

[sqlite] new line now \r\n regardless the OS

Dear All, it looks like we are back in town with '\n' at the end of a line **even in CSV** mode. Can anyone please confirm me (ccing me since apparently I'm not part of this ML) that SQLite no longer forces RFC4180 \r\n ? Thank you! On Sun, Aug 17, 2014 at 7:28 PM, Andrea Giammarchi < andrea.g

[sqlite] new line now \r\n regardless the OS

On 2/25/15, Andrea Giammarchi wrote: > Dear All, > it looks like we are back in town with '\n' at the end of a line **even > in CSV** mode. > > Can anyone please confirm me (ccing me since apparently I'm not part of > this ML) that SQLite no longer forces RFC4180 \r\n ? > I get \r\n in CSV outp

Re: [sqlite] new line now \r\n regardless the OS

hi . please. I do not think you answer to my mail. no problem. is the moment, my problem is : cross-compiling with sqlite.c, .h etc with Eclipse LUNA on Windows XP for Raspberry debian. I need to understand what is happening. to understand, i go to your site at the adress www.sqlite.org

Re: [sqlite] new line now \r\n regardless the OS

Something went wrong with this discussion, I'll quickly thank Richard for the answer. Best Regards On Mon, Aug 18, 2014 at 2:03 PM, olivier BOURQUARD wrote: > hi . > please. > I do not think you answer to my mail. > no problem. > > is the moment, my problem is : cross-compiling with sqlite.c,

Re: [sqlite] new line now \r\n regardless the OS

For more details, this is the thread where the change was proposed: http://sqlite.1065341.n5.nabble.com/Producing-RFC4180-compliant-CSV-output-td76924.html The change that was made allows configuring of the record separator with ".seperator". Hope that helps, - Peter On 18 August 2014 13:18, R

Re: [sqlite] new line now \r\n regardless the OS

On Sun, Aug 17, 2014 at 2:28 PM, Andrea Giammarchi < andrea.giammar...@gmail.com> wrote: > I wonder if this is meant to be or not, it seems that starting from version > `3.8.6` sqlite3-cli/shell now uses only \r\n strings instead of using the > default new line in the OS. > You mean in CSV output

[sqlite] new line now \r\n regardless the OS

I wonder if this is meant to be or not, it seems that starting from version `3.8.6` sqlite3-cli/shell now uses only \r\n strings instead of using the default new line in the OS. This broke badly a spawned parser of mine but I'd like to know the rationale behind this choice, it does not feel right