title: MYSQL: Inserting Traditional & Simplified Chinese in the same 'cell‘
body: <p>newbie here!</p>
  
  <p>I have source data that contains both simplified and traditional Chinese in the same 'cell' (sorry, newbie using Excel speak here!), which I'm trying to load into MYSQL using "Load Data Infile".</p>
  
  <p>The offending text is "到达广州新冶酒吧！一杯芝華士 嘈雜的音樂 行行色色的男女". It's got both simplified Chinese ("广") and traditional Chinese ("華").</p>
  
  <p>When I load it into MySQL, I get the following error:</p>
  
  <blockquote>
    <p>Error Code: 1366. Incorrect string value: '\xF0\xA3\x8E\xB4\xE8\x83...' for column > 'Description' at row 2</p>
  </blockquote>
  
  <p>The collation of the database is UTF-8 default collation, and the input file is also UTF-8 encoded. </p>
  
  <p>Is there any way I can either:</p>
  
  <p>a) Make SQL accept this row of data (ideal), or 
  b) Get SQL to skip inserting this line of data?</p>
  
  <p>Thanks! Do let me know if you need further detail.</p>
  
  <p>Kevin</p>