Default forward data type mappings for Teradata data sources

The following table lists the default forward data type mappings for Teradata data sources.

Table 1. Teradata default forward data type mappings (Not all columns shown)
Remote Typename Remote Lower Len Remote Upper Len Remote Lower Scale Remote Upper Scale Remote Bit Data Remote Data Operators Federated Typename Federated Length Federated Scale Federated Bit Data
BIGINT1 - - - - - - BIGINT1 - - -
BLOB 1 2097088000 - - - - BLOB - - -
BYTE 1 254 - - - - CHAR - - Y
BYTE 255 32672 - - - - VARCHAR - - Y
BYTE 32673 64000 - - - - BLOB - - -
BYTEINT - - - - - - SMALLINT - - -
CHAR 1 254 - - - - CHARACTER - - -
CHAR 255 32672 - - - - VARCHAR - - -
CHAR 32673 64000 - - - - CLOB - - -
CLOB 1
2097088000
(Latin)
 - - - - CLOB - - -
CLOB 1
1048544000
(Unicode)
 - - - - CLOB - - -
DATE - - - - - - DATE - - -
DATE - - - - - - TIMESTAMP2 - - -
DECIMAL 1 313 0 313 - - DECIMAL - - -
DOUBLE PRECISION - - - - - - DOUBLE - - -
FLOAT - - - - - - DOUBLE - - -
GRAPHIC 1 127 - - - - GRAPHIC - - -
GRAPHIC 128 16336 - - - - VARGRAPHIC - - -
GRAPHIC 16337 32000 - - - - DBCLOB - - -
INTEGER - - - - - - INTEGER - - -
INTERVAL - - - - - - CHAR - - -
NUMERIC 1 18 0 18 - - DECIMAL - - -
REAL - - - - - - DOUBLE - - -
SMALLINT - - - - - - SMALLINT - - -
TIME 0 21 0 21 - - TIME - - -
TIMESTAMP(p) - - p p - - TIMESTAMP(6) 10 6 -
VARBYTE 1 32762 - - - - VARCHAR - - Y
VARBYTE 32763 64000 - - - - BLOB - - -
VARCHAR 1 32672 - - - - VARCHAR - - -
VARCHAR 32673 64000 - - - - CLOB - - -
VARGRAPHIC 1 16336 - - - - VARGRAPHIC - - -
VARGRAPHIC 16337 32000 - - - - DBCLOB - - -
Notes:
  1. The BIGINT data type applies to Teradata version 2 release 6 or later.
  2. The federated type is TIMESTAMP(0) if the date_compat configuration parameter is set to ON.
  3. The remote upper length and remote upper scale value 31 applies to the Teradata version 2 release 6 or later. For earlier versions, this value is 18.