SAP Knowledge Base Article - Preview

3017676 - How to prevent varchar from truncating spaces while inserting data into a table? - SAP ASE


  • Inserted a string value into a table with spaces at the beginning and end of its value.
  • When querying the data from a table, the space at the end was trimmed off.
  • Is this a normal behavior for varchar datatype?
  • How can I keep the space at the end of the value?



SAP Adaptive Server Enterprise (ASE)


SAP Adaptive Server Enterprise 16.0


datatype, varchar, nchar, space, trimming, truncating, T-SQL, data, table, insert , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.