title: csv import from unicode to utf8 phpmyadmin
body: <p>I want to import some Chinese Characters into the MySQL database. But some of the content is omitted, and some is showing non-sense. With the pictures shown below:</p>
  
  <p>What's in the database:</p>
  
  <p><img src="https://i.stack.imgur.com/Wy5Et.jpg" alt="enter image description here"></p>
  
  <p>What's in the excel file:</p>
  
  <p><img src="https://i.stack.imgur.com/UyyY3.jpg" alt="enter image description here"></p>
  
  <p>Thank you!</p>
  
  <p>Hi, here is the addtional information:</p>
  
  <p>text document</p>
  
  <pre><code>巴掌  bāzhang (a slap of the) palm     打  beat    human activities
  巴掌  bāzhang (a slap of the) palm     搧  spank   human activities
  巴掌  bāzhang (a slap of the) palm     揍  hit human activities
  把   bá  tools and objects with a handle 扫帚  broom   tools
  把   bá  tools and objects with a handle 锁   lock    man-made
  </code></pre>
  
  <p>show create table</p>
  
  <pre><code>CREATE TABLE `table 1` (
   `CL_in_Character` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
   `CL_in_Pinyin` varchar(14) CHARACTER SET utf8 DEFAULT NULL,
   `Definition_in_Dictionary` varchar(74) CHARACTER SET utf8 DEFAULT NULL,
   `Associated_nouns_in_Chinese` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
   `Associated_nouns_in_English` varchar(38) CHARACTER SET utf8 DEFAULT NULL,
   `Associated_noun_categories` varchar(38) CHARACTER SET utf8 DEFAULT NULL
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
  </code></pre>