Default Result for Character Data | Data Types and Literals | Teradata Vantage - 17.10 - Default Result for Character Data - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

The following table shows the default if a CREATE TABLE, ALTER TABLE, or SELECT statement does not include the FORMAT phrase.

IF the data type is … THEN …
CHARACTER return the full length specified for a fixed-length CHARACTER column (that is, pad characters are returned unless TRIM is included in the SELECT statement).
VARCHAR return the actual character string.
CLOB
  • If the server character set is LATIN and the length of the CLOB is < 64000, then return the actual character string.
  • If the server character set is LATIN and the length of the CLOB is ≥ 64000, then return the first 64000 characters.
  • If the server character set is UNICODE and the length of the CLOB is < 32000, then return the actual character string.
  • If the server character set is UNICODE and the length of the CLOB is ≥ 32000, then return the first 32000 characters.