title: RS-DBI driver warning: (unrecognized MySQL field type 7 in column 1 imported as character)
body: <p>I'm trying to run a simple query that works with MySQL or other MySQL connector API's,</p>
  
  <pre><code>SELECT * FROM `table` WHERE type = 'farmer'
  </code></pre>
  
  <p>I've tried various methods using the RMySQL package and they all get the same error
  <code>RS-DBI driver warning: (unrecognized MySQL field type 7 in column 1 imported as character)</code> </p>
  
  <pre><code>Type = 'farmer'
  (Query&lt;-paste0("SELECT * FROM `table` WHERE type = '%",Type,"%'")) 
  res&lt;-dbGetQuery(con, Query)
  
  Query&lt;-paste("SELECT * FROM `table` WHERE type = \'farmer\'")
  
  
  
  Query&lt;-paste("SELECT * FROM `table` WHERE type = 'farmer'")
  </code></pre>
  
  <p>What am I doing wrong?</p>