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.
SAP Knowledge Base Article - Preview