Re: [sqlite] How does SQLite handle \r and \n in values?

2017-09-21 Thread heribert
The used developing environment is an old one, this may case this error. I'm currently adding some new features to application compiled with MS VC98. The strings i'm using are UTF8-coded. I will mail a short sample and  the resulting error code today. Am 21.09.2017 um 20:18 schrieb Simon

Re: [sqlite] How does SQLite handle \r and \n in values?

2017-09-21 Thread Simon Slavin
On 21 Sep 2017, at 5:00pm, heribert wrote: > I'm using c++ and generate the whole insert string via sqlite3_vmprintf with > quoted text. So the '\r' and '\n' are single characters - this will result in > the error. Something is wrong with your development

Re: [sqlite] How does SQLite handle \r and \n in values?

2017-09-21 Thread R Smith
On 2017/09/21 3:56 PM, heribert 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

Re: [sqlite] How does SQLite handle \r and \n in values?

2017-09-21 Thread heribert
I'm using c++ and generate the whole insert string via sqlite3_vmprintf with quoted text. So the '\r' and '\n' are single characters - this will result in the error. @J.King: I followed your hint to bind the values. Works now as expected. The c strings are now correctly inserted. Am

Re: [sqlite] How does SQLite handle \r and \n in values?

2017-09-21 Thread Richard Hipp
On 9/21/17, heribert wrote: > > 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 >

Re: [sqlite] How does SQLite handle \r and \n in values?

2017-09-21 Thread J. King
More details would help. How are you inserting the data? Are you using a bound parameter (you should be), or quoted text? Are you using something other than the C interface to interact with the database? Which error did you receive? Can you provide a minimal example of the code you used? On

Re: [sqlite] How does SQLite handle \r and \n in values?

2017-09-21 Thread Bart Smissaert
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 wrote: > Hello, > > i attempt to make a INSERT with a TEXT field containing a string with \r > and \n