I needed this recently and for a line break this worked: 'text before linebreak' || char(10) || 'text after linebreak'
RBS On Thu, Sep 21, 2017 at 2:56 PM, heribert <herib...@scharnagl.com> wrote: > Hello, > > i attempt to make a INSERT with a TEXT field containing a string with \r > and \n characters, but it fails (Strings without \r and \n characters are > inserted correct). > The sqlite3_exec results with error... i think the reason are the special > characters. > What is the correct way to store strings containing \r and \n in a TEXT > field? > > Thx for any hint > heribert > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
