Stef Mientki <[EMAIL PROTECTED]> wrote:
This might be a stupid question,
but how do you store quotes in textstrings ?
Is it really so that you have to replace,
both single and double quotes,
each time you read or write something ?
You need to escape single quotes if you insist on putting string
literals directly into queries. No other characters need to be escaped.
See also sqlite3_mprintf.
However, I recommend using parameterized queries and binding your
strings to parameters. Then you don't need to worry about escaping at
all.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------