On 2/4/16, Eric Grange <zarglu at gmail.com> 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 browsers. Ideally CR / LF should be encoded > as \r and \n respectively. > > Is it by design or an oversight?
Oversight. https://www.sqlite.org/src/tktview/ad2559db380a > > Is there a way around using the replace() function to fix it? (though I > guess other control characters will have the issue, so multiple replace() > would be needed) > > Eric > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org
