title: select with trim trailing blanks of char in db2
body: <p>how do I remove trailing blanks in a select on a char(32)?</p>
  
  <pre><code>db2 "create table test (col1 char(32))"
  db2 "insert into test values ('one')"
  </code></pre>
  
  <p>I tried</p>
  
  <pre><code>db2 "select cast(trim(t ' ' from col1 ) as varchar(32)) from test"
  db2 "select trim(t ' ' from cast(col1  as varchar(32)) from test"
  db2 "select cast(trim(t ' ' from cast(col1  as varchar(32))) as varchar(32)) from test"
  </code></pre>
  
  <p>... but I always have trailing blanks </p>