Teradata data types

Teradata data types

Teradata data types can be categorized as follows.

1) Character data:

This is character data that can be fixed or variable length.

The data types can be CHAR, VARCHAR, CHAR VARYING, LONG VARCHAR.

2) Arithmetic Numeric data:

This is numeric data that can have arithmetic operations performed on it.

This numeric data is usually money or quantity values.

The data types can be DATE, DECIMAL, NUMERIC, BYTEINT, SMALLINT, INTEGER, REAL, DOUBLE PRECISION, or FLOAT.

The arithmetic operations can be:

SUM(t1.c1), MAX(t1.c1), t1.c1 + t2.c1, etc.

3) Non-Arithmetic Numeric data:

This is numeric data that will not have arithmetic operations performed on it.

This numeric data is usually code or id values, and usually, is not money or quantity values.

The data types can be DATE, DECIMAL, NUMERIC, BYTEINT, SMALLINT, INTEGER, REAL, DOUBLE PRECISION, or FLOAT.

4) Byte  data:

This is bit oriented data, with hexadecimal orientation of values.

This data type is not currently used in the EDW application tables.

The data types can be BYTE, VARBYTE.

This data will not be covered as part of this NULL topic.

5) Graphic data:

This is Japanese Kanji oriented data, with a mixture of single and multiple bytes representing the Japanese language.

This data type is not currently used in the EDW application tables.

The data types can be GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC.

This data will not be covered as part of this NULL topic.