Gosh, sorry, just re-read the faq:
INSERT INTO xyz VALUES('5 O''clock');----- Original Message ----- From: "Edwin Knoppert" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org> Sent: Tuesday, July 19, 2005 1:49 PM Subject: [sqlite] How to store ' ?
If i read correct BLOB data can now handle chr(0) as well. But another issue i solved with access is the embedding of ' characters. I'm using single quotes for field data during INSERT. How can a field contain single quotes for data? Access allows to use BASIC code and let's you insert + Chr() stuff.
