Single quotes in sqlite on android Single quotes in sqlite on android sqlite sqlite

Single quotes in sqlite on android


stockservicevalue=stockservicevalue.replaceAll("'", "\''"); 


We can make use android DatabaseUtils class.

stockservicevalue= DatabaseUtils.sqlEscapeString(stockservicevalue);


I think the correct format would be stockservicevalue=stockservicevalue.replaceAll("\'", "\"");