title: Can't import Japanese characters from XML to MySQL
body: <p>I've been trying to load some dictionary files into a MySQL Database for a while but I can't figure out how to do it.</p>
  
  <p>Example of an XML entry:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;entry&gt;
  &lt;keb&gt;召す&lt;/keb&gt;
  &lt;reb&gt;めす&lt;/reb&gt;
  &lt;sense&gt;
  &lt;gloss&gt;to call&lt;/gloss&gt;
  &lt;gloss&gt;to invite&lt;/gloss&gt;
  &lt;/sense&gt;
  &lt;sense&gt;
  &lt;gloss&gt;to eat&lt;/gloss&gt;
  &lt;gloss&gt;to drink&lt;/gloss&gt;
  &lt;/sense&gt;
  &lt;/entry&gt;
  </code></pre>
  
  <p>So  is one word. When I import this using LOAD XML LOCAL INFILE the columns which are supposed to store the Japanese characters are just left blank. How can I fix this?</p>
  
  <p>I've tried to set my keb and reb rows in the table to utf8_bin and utf8_unicode_ci but still they are just left blank. I'm using PHPMyAdmin if that is any help.</p>
  
  <p>Thank you!</p>