Remove extra padding blanks in char columnTag(s): Common problems

If a char(5) column contains only "a", some drivers are returning "a     " and some "a" with the extra spaces removed.

For example, the trimming is done with SQLServer or Access but not for DB/2 or Ingres DBMS. Padding blanks in Char column are Ok according to the ANSI SQL standard it may be easier to assume that extra right spaces are trimmed.

You can let PB do the job for you by adding this parameter in the PBODB60.INI file (in the Sybase Shared folders) : 

PBTRIMCHARCOLUMNS='YES'
in the section for your DBMS. With that setting, Pb will trim blanks in datawindows only.

If you find this article useful, consider making a small donation
to show your support for this Web site and its content.

Written and compiled by Réal Gagnon ©1998-2012
[ home ]