title: How to write binary data into SQLite with R DBI's dbWriteTable()?
body: <p>For instance, how to execute the equivalent following SQL (which inserts into a <code>BINARY(16)</code> field)</p>
  
  <pre><code>INSERT INTO Table1 (MD5) VALUES (X'6717f2823d3202449201145073ab871A'),(X'6717f2823d3202449301145073ab371A')
  </code></pre>
  
  <p>using <code>dbWriteTable()</code>? Doing</p>
  
  <pre><code>dbWriteTable(db, "Table1", data.frame(MD5 = "X'6717f2823d3202449201145073ab871A'", ...), append = T, row.names = F)
  </code></pre>
  
  <p>doesn't seem to work - it writes the values as text.</p>
  
  <p>In the end, I'm going to have a big data.frame of hashes that I want to write, and so perfect for using <code>dbWriteTable</code>. But I just can't figure out how to <code>INSERT</code> the <code>data.frame</code> into <em>binary</em> database fields.</p>