SAP Knowledge Base Article - Preview

2349625 - Text data type in ASE: Why does a "text" column accept only 16384 bytes sometimes

Symptom

In some cases, you could try to insert a string into a text column using command "insert ... values ...". If the string value you would like to insert is longer than 16384 bytes, 
and  the specified value for the text column is a string variable or a string expression concatenating multiple substrings with operator "+", you will encounter a problem,
that is, the maximum size allowed to be inserted into the text column is only 16384 bytes, the other part of string longer than 16384 bytes will be truncated automatically
by ASE server, and no any error or warning message is raised. You will find the problem when checking the length of text column using function len().


Read more...

Environment

SAP Adaptive Server Enterprise 16.x

Product

SAP Adaptive Server Enterprise 16.0

Keywords

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.