LOB Limitations - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
ktb1507075385726
Product Category
Teradata Tools and Utilities

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.