Re: [sqlite] Re: Quotes in SQLite ?

2007-02-27 Thread Stef Mientki
Dennis, Igor thanks very much, I think I'm getting the picture. cheers, Stef - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Quotes in SQLite ?

2007-02-27 Thread Dennis Cote
Stef Mientki wrote: I've to translate doublequotes too, possibly because I'm using double quotes around textfields ??, Is that wrong ? Not wrong,but not standard either. The SQL standard uses single quotes for string literals and double quotes for quoted identifiers (names that contain special

Re: [sqlite] Re: Quotes in SQLite ?

2007-02-27 Thread Stef Mientki
Igor Tandetnik wrote: 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 yo

[sqlite] Re: Quotes in SQLite ?

2007-02-27 Thread Igor Tandetnik
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 strin