While I await some insight into my previously posted "database locking"
problem, I have a question regarding quoting text.
Does SQLite have any issues with anything other than single-quotes? For
example, with colon, or semi-colon?
For example, I find occasional complaints if I try to update/insert a
string like --
$text = 'Some long-winded text with lot''s of different things like:
* lists
* more lists
text with semi-colon; and even such: stuff.';
UPDATE tbl SET col = $text WHERE ...
causes error to effect that sql prepare failed (again, Perl/DBI
specific errors).
--
Puneet Kishor
