Default Result for Character Data

Teradata Vantage™ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

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.