title: RMySQL, dbWriteTable, and text fields containing newlines
body: <p>I have an R routine which needs to write text from third parties to a MySQL database.  That text often contains newlines.</p>
  
  <p>Unfortunately,</p>
  
  <pre><code>foobar &lt;- as.data.frame(a=1, b='\n')
  dbWriteTable(MySQL(), foobar, 'test')
  </code></pre>
  
  <p>creates a table with <em>two</em> records; the '\n' generates a record break and an empty record.</p>
  
  <p>IS there something special about RMySQL?  Is this a well known issue?  I've looked around a lot, and I haven't seen anyone discuss it.  Is there a workaround short of using a different connector?</p>