title: how to use pentaho kettle to insert double byte(Chinese/Japanese) into MS SQL DB?
body: <p>I put all the data in a spreadsheet, which contains Japanese. In order to save those Japanese characters correctly, I saved the spreadsheet as UNICODE txt. Then I open it, I can see those Japanese display well.</p>
  
  <p>Then I change the .txt extension to .csv(open it still displays Japanese well), and put it into kettle inbox folder. </p>
  
  <p>But after run the kettle, I found the value in db table is ??.</p>
  
  <p>In .ktr file for extracting the value of .csv, the column contains Japanese is defined as string.</p>
  
  <p>In spoon, I already change the .csv file encoding is UTF-16 and format is mixed(dos&amp;unix)</p>
  
  <p>In the stored procedure for inserting the data into db table, the variable holds the Japanese is defined as nvarchar(255).</p>
  
  <p>So I do not know how to solve this issue, please help. Thanks in advance.</p>