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');
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]
>
> -----------------------------------------------------------------------------
>
>
