title: JDBC - Configure white-spaces from 'char' datatype
body: <p>How can JDBC be configured to automatically trim white-spaces coming from a column where the data type is defined as a <code>char(20)</code>?</p>
  
  <p>When a column has a char(xx) defined in a table of an Informix database, each of those reserved characters will be filled with white-spaces if not used.</p>
  
  <p><strong>Ex.:</strong> Column name <em>prefix</em> of type <code>char(20)</code> with a value of "test" will ultimately be read as:</p>
  
  <pre><code>"test                " &lt;- 4 characters + 16 white-spaces
  </code></pre>
  
  <p>Is there a configuration file which can handle white-spaces from these types of database fields?</p>