SAP Knowledge Base Article - Preview

1267193 - What does the ANSI_Varchar_Behavior setting do? - Data Integrator 11.5.x and later/Data Services XI


  • How does the software handle NULL values?
  • How does the software handle blank values?
  • Are trailing spaces evaluated in varchar fields when doing comparisons?
  • Case statements evaluating NULLs and blanks are not working correctly.
  • What is the meaning / impact of the flag ANSI_VARCHAR_BEHAVIOR in DSConfig.txt?



  • Data Integrator 11.5 and later
  • Data Services All Versions


SAP Data Integrator XI R2 ; SAP Data Services all versions


DI , varchar , ANSI_VARCHAR_BEHAVIOR , DS , DSXI , Data Services , KBA , EIM-DI , Data Integrator, Composer , EIM-DS , Data Services , 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.