Large Objects and INSERT - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

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.