On Wed, 2007-11-14 at 15:38 +0200, Jevgenijs Rogovs wrote:
> Thanks, but how do I use those?
> See, I have a huge file of INSERT statements, which look like this:
>
> INSERT INTO sometable VALUES ('blablabla\r\nyadayadayada');
>
> What I need is to import this data into SQLite database. If I change all
> \r\n occurances into the following:
>
> INSERT INTO sometable VALUES ('blablabla'||x'0A'||'yadayadayada');
Is it possible that you have mismatched quotes in the
preprocessed script? The statement above runs fine here.
Dan.
> I'm getting "Expression tree is too large (maximum depth 1000)" error...
>
> Any ideas on how to cope with this?
>
> Thanks again!
>
> With best regards,
> J.R.
>
> On Nov 14, 2007 3:19 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
>
> > Jevgenijs Rogovs <[EMAIL PROTECTED]>
> > wrote:
> > > Could someone please assist me with the following: how do I insert a
> > > string into an SQLite database that contains a CR or LF character?
> > > C-style escapes (like \r and \n) are not working with SQLite, so how
> > > can I do this?
> >
> > Use parameterized statements - see sqlite3_prepare[_v2], sqlite3_bind_*,
> > sqlite3_step et al.
> >
> > Igor Tandetnik
> >
> >
> >
> > -----------------------------------------------------------------------------
> > To unsubscribe, send email to [EMAIL PROTECTED]
> >
> > -----------------------------------------------------------------------------
> >
> >
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
