CHAR(1) columns turning into lengths of 2 with spaces in Exports
LAMPHIC
Registered Posts: 3 ✭
We have to use data preps from many database tables on different platforms that have columns defined as CHAR(1) to keep them as length's of 1. Otherwise the exports change them to lengths of 2 with spaces added on. So, an indicator column with only "Y" or "N" becomes "Y " (added space) or "N " (added space).
Using a data prep recipe to keep these a 1 character length columns adds an unnecessary pass of files. We do large files so this is very time consuming.
Can we add an option on the EXPORT recipe to keep CHAR(1) columns as CHAR(1) and not put the space on them making them lengths of 2?