Teradata SQL and LOB Types - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

Table columns containing LOB data can be created using a Create Table SQL statement in the following manner.

CREATE TABLE FOO (	
     C01 INTEGER,
     C02 BLOB,
     C03 CLOB);

The CONVERT function of ODBC Driver for Teradata supports BLOB and CLOB data types.

CONVERT will map

"{fn CONVERT(value_exp, SQL_LONGVARBINARY)}" to
"(value_exp (BLOB))"

and

"{fn CONVERT(value_exp, SQL_LONGVARCHAR)}" to "(value_exp(CLOB))".