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.