title: Informatica Powercenter data truncation/overflow error
body: <p>I'm trying to make a simple data loading with an IPC mapping from one Oracle DB to another.</p>
  
  <p>The source table structure is following:</p>
  
  <pre><code>ID  NUMBER;
  C_VALUE VARCHAR2 (16);
  C_CODE  VARCHAR2 (16);
  SN  NUMBER;
  SU  NUMBER;
  </code></pre>
  
  <p>The target table structure is following:</p>
  
  <pre><code>ID  NUMBER
  C_VALUE VARCHAR2 (20)
  SSID    NUMBER
  LOADID  NUMBER
  LOADROWNUMBER   NUMBER
  DATEBEGIN   DATE
  DATEEND DATE
  </code></pre>
  
  <p>When I'm running the workflow I'm getting the following error:</p>
  
  <blockquote>
    <p>8340||Error: Target table [TYPE_ACC_RRB] data truncation/overflow
    error.</p>
  </blockquote>
  
  <p>When I'm trying to debug my mapping, I'm seing that my input string in the <code>c_value</code> field is presented by the unicode characters and it's length is doubled in bytes.</p>
  
  <p>Does the Informatica count chars of bytes as the length of it's string fields?
  How to make it see for chars, not for bytes?</p>
  
  <p>What I see from the session log is:</p>
  
  <pre><code>Server Mode: [UNICODE]
  Server Code page: [UTF-8 encoding of Unicode]
  The session sort order is [Binary].
  Source database connection [RBO01] code page: [MS Windows Cyrillic (Slavic)]
  Target database connection [STG1] code page: [MS Windows Cyrillic (Slavic)]
  </code></pre>
  
  <p>My mapping:</p>
  
  <p><img src="https://i.stack.imgur.com/xdjfo.png" alt="enter image description here"></p>