Processing of single quotes in Android SQLite strings

Http://www.cnblogs.com/Mr_JinRui/archive/2010/05/12/1733662.html
(32) SQLite inserts a string with single quotes (')
Use double single quotes, for example:
Insert into XYZ values ('5 o' 'clock ');
The database to be inserted is: 5 0' clock.

The SQLite standard uses single quotes to wrap strings.
If contentvalue is used for insertion, Android will automatically process the single quotation marks in the string, so you do not have to handle them yourself.
The strings in the SQLite statement must be replaced ("'", "'' ").