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]
-----------------------------------------------------------------------------

Reply via email to