CLOB Data Type | Data Types and Literals | VantageCloud Lake - CLOB Data Type

CLOB Data Type | Data Types and Literals | VantageCloud Lake - CLOB Data Type - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

ft:locale

en-US

ft:lastEdition

2024-12-11

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

CLOB LATIN/UTF16 is only supported on the Block File System on the primary cluster. It is not available for the Object File System.

Represents a large character string. A character large object (CLOB) column can store character data, such as simple text or HTML.

A CLOB column can store XML or JSON documents; however, Teradata recommends that you use the Teradata XML and Teradata JSON data types for that purpose.

CLOB Data Type Syntax
CLOB Data Type Usage Notes
CLOB Data Type Examples

ANSI Compliance

CLOB is ANSI SQL:2011 compliant.