LOB Limitations

ODBC Driver for Teradata® User Guide

brand
Teradata Tools and Utilities
prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

Presently BLOB and CLOB Large Object types are limited to a size of about 2 GB (2,097,088,000 bytes or characters). If the character set of a CLOB column is defined with Unicode for its character set, it has a maximum size limit of approximately 1 GB.