SAP Knowledge Base Article - Preview

3345442 - Data exception not reported when using "set string_rtruncation on" - SAP ASE

Symptom

  • Not receiving the expected "Data exception" message when inserting a value that is wider than the column definition.
  • Example: insert a 7 character wide value into a column that is a varchar(3)
    set string_rtruncation on
    go
    insert into t (c1) values ("1234567")
    go
    (1 row affected)
     
  • Expected result:
    Msg 9502, Level 16, State 19:
    Server 'myase', Line 2:
    Data exception - string data right truncated
    Command has been aborted.
    (0 rows affected)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions

Keywords

string_rtruncation, statement cache , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.