title: ORA-29275: partial multibyte character
body: <p>I have input data coming from a flat file which has english, japanese, chinese characters in one column.
  I am loading these values in a staging table column whose schema definition is VARCHAR2(250 CHAR),  the main table column has definition VARCHAR2(250) WHICH i can not change.
  So, i am doing a SUBSTR on this column. After loading the table when i did a </p>
  
  <pre><code>SELECT * FROM TABLE
  </code></pre>
  
  <p>...I get this error :</p>
  
  <blockquote>
    <p>ORA-29275: partial multibyte character</p>
  </blockquote>
  
  <p>If i select other columns then no issues.</p>