Hi John,
On 19/03/2006, at 18:23, John Stanton wrote:
Tito Ciuro wrote:
Hello,
I'm trying to store a string and I get the following error:
unrecognized token: \"!\"\"
This happens with SQLite 3.2.7
Any ideas?
Thanks,
-- Tito
What is the string?
If I escape single quotes (that is, from "'" to "''"), then
everything is fine. I usually do that when I want to query for a
value that contains a quote (i.e. O'Rourke).
However, why do I have to manipulate the string value to be stored?
Shouldn't SQLite allow me to store any string I want?
Thanks,
-- Tito