title: Using Chinese characters in mysql table
body: <p>I'm trying to use Chinese characters in mysql table. On my first try I wrote something like 中文考试 and my table came back with <code>è¿˜æœ‰ä¸€ä¸ªè€ƒè¯•</code>.</p>
  
  <p>After research, it was suggested that I use the UTF-8 as my character set. I went back to my table and altered the character set with the command</p>
  
  <pre><code>ALTER TABLE posts CONVERT TO CHARACTER SET utf8;
  </code></pre>
  
  <p>I tried writing Chinese characters again and got the same result - (  <code>è¿˜æœ‰ä¸€ä¸ªè€ƒè¯•</code>.).</p>
  
  <p>Here is a copy of my table as it exist right now:</p>
  
  <p><img src="https://i.stack.imgur.com/Q0h3M.png" alt="enter image description here"></p>
  
  <p>How can I get my table to accept Chinese characters?</p>