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
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
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
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
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
>
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
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
7 matches
Mail list logo