title: Data truncation and null input strings
body: <p>I am working in Talend and have managed to get data from a CSV file and filter it before putting into a table. The problem I am having now is to do with the length of the data.</p>
  
  <p>This is the red text I get:</p>
  
  <pre><code>For input string: "null"
  For input string: "null"
  For input string: "null"
  Data truncation: Data too long for column 'Street' at row 58
  For input string: "null"
  For input string: "null"
  For input string: "null"
  For input string: "null"
  For input string: "null"
  Data truncation: Data too long for column 'Street' at row 23 
  ...
  </code></pre>
  
  <p>etc.</p>
  
  <p>I have changed the length of the data in my schema such that it is propagated everywhere. I really don't know what to do to resolve this.</p>