title: Difficulty in escaping single quote character while SQLite database insertion
body: <p>I have to insert certain text in database which may contain characters with single quotes and double quotes.</p>
  
  <p>For eg: <strong>"Lumix"</strong> or something like <strong>Vijay's</strong> </p>
  
  <p>I have successfully escaped the double quotes like this:</p>
  
  <pre><code>if(fdata.search('"') != -1) {
  
  
  fdata = fdata.replace(/(['"])/g, "\\$1");
  
  
  
  }  
  </code></pre>
  
  <p>But I am not understanding how to escape the single quotes. Without escaping the single quotes SQLite is not accepting the data. How to solve the issue? Thanks in advance!</p>