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
<https://tools.ietf.org/html/rfc2046#section-4.1.1> [3
<https://tools.ietf.org/html/rfc4180#ref-3>], this media type uses
CRLF
to denote line breaks. However, implementors should be aware that
some implementations may use other values.
On Wed, Feb 25, 2015 at 8:48 AM, Andrea Giammarchi <
andrea.giammarchi at gmail.com> 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 ?
>
> Thank you!
>
> On Sun, Aug 17, 2014 at 7:28 PM, Andrea Giammarchi <
> andrea.giammarchi at 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.
>>
>> This broke badly a spawned parser of mine but I'd like to know the
>> rationale behind this choice, it does not feel right to find that \r\n in
>> Linux or Mac.
>>
>> Thanks in advance for any clarification, I am just trying to fix properly
>> an open source library of mine that suddenly does not work anymore.
>>
>> Best Regards
>>
>
>