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