title: Special characters won't work in MySQL (UTF-8)
body: <p>So, I've had some issues while trying to come over from <code>Latin1</code> encoded databases, tables as well as columns, and now that everything is finally in UTF-8, I can't seem to update a row in a column. I am trying to replace an "e" with an e with acute (é). But it gives me this:</p>
  
  <blockquote>
    <p>ERROR 1366 (HY000): Incorrect string value: '\x82m ...' for column
    'Name' at row 1</p>
  </blockquote>
  
  <p>when running this:</p>
  
  <p><code>UPDATE access SET Name='ém' WHERE id="2";</code></p>
  
  <p>All databases gives me this when running the status command (except the <code>current database</code> part of course):</p>
  
  <hr>
  
  <pre><code>Connection id:          1  
  Current database:       access  
  Current user:           root@localhost  
  SSL:                    Not in use  
  Using delimiter:        ;  
  Server version:         5.1.47-community MySQL Community Server (GPL)  
  Protocol version:       10  
  Connection:             localhost via TCP/IP  
  Server characterset:    utf8  
  Db     characterset:    utf8  
  Client characterset:    utf8  
  Conn.  characterset:    utf8  
  TCP port:               3306  
  Uptime:                 20 min 16 sec  
  
  Threads: 1 Questions: 110 Slow queries: 0 Opens: 18 Flush tables: 1 Open tables: 11  Queries per second avg: 0.90
  </code></pre>
  
  <hr>
  
  <p>And running the chcp command in cmd gives me <code>850</code>. Oh, and at some points I got this:</p>
  
  <blockquote>
    <p>ERROR 1300 (HY000): Invalid utf8 character string: 'ém' WHERE id="2"</p>
  </blockquote>
  
  <p>I've looked everywhere for a solution, but I couldn't seem to find anything anywhere, and since I've always had good responses on Stackoverflow, I thought I'd ask here.</p>
  
  <p>Thanks for any help!</p>