title: Can we export special characters using sqoop?
body: <p>I'm trying to export one of the tables from hive to MySQL using sqoop export. The hive table data contains the special characters. </p>
  
  <h1>My hive "special_char" table data:</h1>
  
  <pre><code>1   じゃあまた
  2   どうぞ
  </code></pre>
  
  <h1>My Sqoop Command:</h1>
  
  <pre><code> sqoop export --verbose --connect jdbc:mysql://xx.xx.xx.xxx/Sampledb --username abc --password xyz --table special_char --direct --driver com.mysql.jdbc.Driver  --export-dir /apps/hive/warehouse/sampledb.db/special_char --fields-terminated-by ' '
  </code></pre>
  
  <p>After using the above sqoop export command, the data is stored in the form of question marks (???) instead of actual message with special characters.</p>
  
  <h1>MySql "special_char" table:</h1>
  
  <pre><code>id  message
  1    ?????
  2    ??? 
  </code></pre>
  
  <p>Can anyone please help me out,in storing the special characters instead of question marks (???).</p>