SAP Knowledge Base Article - Preview

3075912 - Is there an option to retain padding when bcping out char data?


  • Is there a bcp option to keep the space padding on a char column when using bcp to export data?
  • For example:
    • bcp data is "WM" when the column is nullable char(5) when we need it to be "WM    ". 
      • The replicated update statement where clause looks for "WM    "
      • fails at the target because it was copied in as "WM";
    • This is the expected bcp behavior, per the BCP documentation. 
    • The purpose of keeping the padding is use with SQL*Loader into Oracle, where the full char value is needed. 
    • Just looking for a workaround rather than - Using 'awk/sed' to add spaces to this particular column.



SAP Adaptive Server Enterprise 16.0


SAP Adaptive Server Enterprise 16.0


KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.