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. |