title: Application crash when I insert data in textfield using this character (,"",'') in data base
body: <p>I am  inserting the text field value in data base .Actually my application crash when user use (,"",'')comma single code ,double code.I think we cannot add these character in data base?
  can you please tell me how to remove this character .I should only allow thise charater which don't crash the insert query. I am using sqlite in phonegap.</p>
  
  <p>I found this but this is not good solution because some character allowed in data base</p>
  
  <pre><code>$(document).on("keyup", ".caseName_h", function () {
    if (/[^\w]/g.test($(this).val())) {
      $(this).val($(this).val().replace(/[^\w]/g, ""));
      PG_alert('Special characters not allowed!');
     }
   });
  
   function insertData() {
       db.transaction(createTable, errorCB, afterSuccessTableCreation);
   }
  
   //create table and insert some record
   function createTable(tx) {
       tx.executeSql('CREATE TABLE IF NOT EXISTS CaseTable (id INTEGER PRIMARY KEY AUTOINCREMENT, CaseName  VARCHAR(100) unique NOT NULL ,CaseDate INTEGER ,TextArea VARCHAR(200) NOT NULL)');
  
       tx.executeSql('INSERT OR IGNORE INTO CaseTable(CaseName,CaseDate,TextArea) VALUES ("' + $('.caseName_h').val() + '", "' + $('.caseDate_h').val() + '","' + $('.caseTextArea_h').val() + '")');
  
   }
   //function will be called when an error occurred
   function errorCB(err) {
       navigator.notification.alert("Error processing SQL: " + err.code);
   }
  
   //function will be called when process succeed
   function afterSuccessTableCreation() {
       console.log("success!");
       db.transaction(getallTableData, errorCB);
   }
  
   //select all from SoccerPlayer
   function getallTableData(tx) {
       // tx.executeSql("DROP TABLE IF EXISTS a");       
       tx.executeSql('SELECT * FROM CaseTable', [], querySuccess, errorCB);
   }
  
   /*function querySuccess(){
  for (var i = 0; i &lt; len; i++) {
      alert(result.rows.item(0).CaseName)
          db.transaction(function (tx) {
  
   tx.executeSql('SELECT * FROM "'+result.rows.item(0).CaseName+'"', [],
     // tx.executeSql('SELECT EXISTS(SELECT * FROM  b)', [],
                function(tx, results) {
                 t=results.rows.length;
                 alert(t)
  });
      });
  
  }
  
  }*/
  
   function querySuccess(tx, result) {
       var len = result.rows.length;
       var countDoument = 0
       $('#folderData').empty();
       for (var i = 0; i &lt; len; i++) {
  
           currentTableName = result.rows.item(i).CaseName;
  
           countElements(currentTableName, function (i) {
               return function (result_count) {
                   countDoument = result_count; // here it count value 
  
                   $('#folderData').append(
                       '&lt;li class="caseRowClick" id="' + result.rows.item(i).id + '" data-rel="popup" data-position-to="window"&gt;' + '&lt;a href="#"&gt;' + '&lt;img src="img/Blue-Folder.png"&gt;' + '&lt;h2&gt;' + result.rows.item(i).CaseName + '&lt;/h2&gt;' + '&lt;p&gt;' + result.rows.item(i).TextArea + '&lt;/p&gt;' + '&lt;p&gt;' + result.rows.item(i).CaseDate + '&lt;/p&gt;' + '&lt;span class="ui-li-count"&gt;' + countDoument + '&lt;/span&gt;' + '&lt;/a&gt;' +
                       '&lt;span class="ctrl togg"&gt;&lt;fieldset data-role="controlgroup" data-type="horizontal" data-mini="true" &gt;&lt;button class="edit button_design"&gt;Edit&lt;/button&gt;&lt;button class="del button_design"&gt;Delete&lt;/button&gt;&lt;/fieldset&gt;&lt;span&gt;' + '&lt;/li&gt;');
                   $('#folderData').listview('refresh');
  
               };
           }(i));
       }
   }
   tx.executeSql('INSERT OR IGNORE INTO CaseTable(CaseName,CaseDate,TextArea) VALUES ("' + $('.caseName_h').val() + '", "' + $('.caseDate_h').val() + '","' + $('.caseTextArea_h').val() + '")');
  </code></pre>