[sqlite] How to store ' ?

[Edwin Knoppert]

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.