The behavior of truncated LOB updates differs in ANSI and Teradata session modes. The following table explains the differences in truncation behavior.
|In this session mode …||The following behavior occurs when non-pad bytes are truncated on insertion …|
|ANSI||an exception condition is raised.
The UPDATE fails.
|Teradata||no exception condition is raised.
The UPDATE succeeds: the truncated LOB is stored.