[sqlite] json1 not escaping CRLF characters

2016-02-04 Thread Eric Grange
Thanks! I can make do with replace() for now (as in my particular case, I only have CRLF & TAB to replace) On Thu, Feb 4, 2016 at 11:39 AM, Richard Hipp wrote: > On 2/4/16, Richard Hipp wrote: > > On 2/4/16, Eric Grange wrote: > >> Hello, > >> > >> I have been experimenting with using the

[sqlite] json1 not escaping CRLF characters

2016-02-04 Thread Dominique Devienne
On Thu, Feb 4, 2016 at 11:04 AM, Dominique Devienne wrote: > On Thu, Feb 4, 2016 at 10:43 AM, Eric Grange wrote: > >> I have been experimenting with using the json1 extension to generate json >> sql-side rather than code-side, but I am hitting an issue with the CR & LF >> characters which are

[sqlite] json1 not escaping CRLF characters

2016-02-04 Thread Stephan Beal
On Thu, Feb 4, 2016 at 11:04 AM, Dominique Devienne wrote: > \" represents the quotation mark character (U+0022). > \\ represents the reverse solidus character (U+005C). > \/ represents the solidus character (U+002F). > ... > The wording above doesn't seem to "require" these characters to be

[sqlite] json1 not escaping CRLF characters

2016-02-04 Thread Dominique Devienne
On Thu, Feb 4, 2016 at 10:43 AM, Eric Grange wrote: > I have been experimenting with using the json1 extension to generate json > sql-side rather than code-side, but I am hitting an issue with the CR & LF > characters which are not escaped, which results in json that fails > JSON.parse or use as

[sqlite] json1 not escaping CRLF characters

2016-02-04 Thread Eric Grange
Hello, I have been experimenting with using the json1 extension to generate json sql-side rather than code-side, but I am hitting an issue with the CR & LF characters which are not escaped, which results in json that fails JSON.parse or use as JSONP in browsers. Ideally CR / LF should be encoded

[sqlite] json1 not escaping CRLF characters

2016-02-04 Thread Richard Hipp
On 2/4/16, Richard Hipp wrote: > On 2/4/16, Eric Grange wrote: >> Hello, >> >> I have been experimenting with using the json1 extension to generate json >> sql-side rather than code-side, but I am hitting an issue with the CR & >> LF >> characters which are not escaped, which results in json

[sqlite] json1 not escaping CRLF characters

2016-02-04 Thread Richard Hipp
On 2/4/16, Eric Grange wrote: > Hello, > > I have been experimenting with using the json1 extension to generate json > sql-side rather than code-side, but I am hitting an issue with the CR & LF > characters which are not escaped, which results in json that fails > JSON.parse or use as JSONP in