title: PDO bindParam truncate string after double quote
body: <p>I have a problem with PDO prepare query. When I try to insert a simple string with double quotes like this <strong>'example string " to be inserted in mysql'</strong>, the query result is truncated when the double quotes start and the result in MySQL is <strong>'example string'</strong>.
  Does anyone had this problem with pdo?</p>
  
  <p>This is my query:</p>
  
  <pre><code>    $sql = "UPDATE sales 
          SET note = :note
          WHERE id_sale= :id";
  
      $stmt = $db-&gt;prepare($sql);
      $stmt-&gt;bindParam(':note', $this-&gt;note, PDO::PARAM_STR, 80);
      $stmt-&gt;bindParam(':id', $this-&gt;id, PDO::PARAM_INT);
  
      $stmt-&gt;execute();
  </code></pre>
  
  <p>Thanks in advance!</p>