16.20 - Data Types on Which String Functions can Operate - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1145-162K

The following table lists all the data types that can be processed as strings. Note that not all types are acceptable to all functions. See the individual functions for the types they can process.

Data Type Grouping
Character Byte Numeric
  • CHARACTER
  • VARCHAR
  • CLOB
  • BYTE
  • VARBYTE
  • BLOB
  • BYTEINT
  • DECIMAL
  • FLOAT
  • INTEGER
  • NUMERIC
  • SMALLINT