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.
blog comments powered by Disqus