title: MySql C# Insert Error. Incorrect string value: '\xE1ra'
body: <p>I'm using the C# .NET Mysql Connector, and when running this query:</p>
  
  <pre><code>INSERT INTO convos (`userid`,`time`,`from`,`content`,`read`,`deleted`, `ip`, `source`, `charname`, `to`) VALUES ('3', '1347396787', 'Chára', '........', '0', '0', '0.0.0.0:0000', 'C', 'óóóíííí', 'óóóíííí');
  </code></pre>
  
  <p>I get the following error:</p>
  
  <blockquote>
    <p>Incorrect string value: '\xE1ra' for column 'from' at row 1</p>
  </blockquote>
  
  <p>I understand my encoding, everything was configured for utf8, utf8_general_ci.  Database, table and columns are configured for utf8. The data is sent from the client in utf8.</p>
  
  <p>If i use a 3rd party tool like, Workbench to insert the query or use the mysql command line it works fine. I don't know if there is a bug with the connector or i need to be doing something else with the values before insert?</p>
  
  <p>Any idea?</p>
  
  <p>Thanks</p>
  
  <p>Is there any in mysql to covert to the correct type?</p>