Teradata support many datatypes for data storage and processing. Some of them are described below.
| Datatype | Description |
| Char(n) | Represents a fixed length character string of upto n charater. |
| Varchar(n) | Represents a variable length character string of length 0 to n. |
| Clob | Represents a variable length Character Large Object (CLOB) of length 0 to n. |
| Graphic(n) | This is an alias for 'Char(n) Character Set Graphic'. |
| Vargraphic(n) | This is an alias for 'Varchar(n) Character Set Graphic'. |
| JSON(n) | Represents a variable length JavaScript Object Notation (JSON) of length 0 to n. |
| ByteInt | Represents a 8-bit (1-byte) integer.
Range: -128 to 127 |
| BigInt | Represents an 64-bit (8-byte) integer.
Range: -9,223,372,036,854,775,808 to 9,223,372,036,854,775,80 |
| Decimal(m,n) | Represents a decimal number with maximum precision of 38 but it can range from 1 to 38. The scale can range from 0 to 38 but it must be less than or equal to the precision. |
| Double | Double Represents a 64-bit double-precision number.
Range: ±2.226 x 10-308 to ±1.797 x 10308 |
| Integer | Represents a 32-bit (4-byte) integer.
Range: -2,147,483,648 to 2,147,483,647. |
| Number | Represents a fixed or floating point decimal.
For fixed decimals the maximum precision is 38 and the scale can range from 0 to 38. The scale must be less than or equal to the precision. For floating decimals the mantissa can contain up to 38 digits, and the exponent can range from -130 to 125. |
| SmallInt | Represents a 16-bit (2-Byte) integer.
Range: -32,768 to 32,767 |
| Date | Date data type has Year, Month and Day components.
The range of values are from January 1, 01 through December 31, 9999. |
| Time(n) | Time data type has Hour, Minute, Second and Fractional Second components.
'n' represent the number of digits for the Fractional-Second component ranges from 0 to 6. The Teradata Database defaults the fractional seconds to 6 digits. The range of values are from 00:00:00.000000 through 23:59:59.999999. |
| Time(n) With Time Zone | Time With Time Zone data type has Hour, Minute, Second, Fractional-Second, Time Zone Hour and Time Zone Minute components.
Time Zone range of values are from -12:59 through +14:00. |
| Timestamp(n) | Timestamp data type has Year, Month, Day, Hour, Minute, Second and Fractional-Second components.
The range of values are from January 1, 01 00:00:00.000000 through December 31, 9999 23:59:59.999999. |
| Timestamp(n) With Time Zone | Timestamp data type has Year, Month, Day, Hour, Minute, Second, Fractional-Second, Time Zone Hour and Time Zone Minute components.
The Time Zone range of values are from -12:59 through +14:00. |
| Datatype | Description |
| Byte(n) | Specifies a fixed length column of length 'n' for binary string data. The maximum value for 'n' is 64000. |
| VarByte(n) | Specifies a varying length column of length 'n' for binary string data. The maximum value for 'n' is 64000. |
| Blob | Specifies a variable length Binary Large Object (BLOB). |
| Character Set Name | Description |
| LATIN | Fixed 8-bit characters from the ASCII ISO 8859 Latin1 or ISO 8859 Latin9 repertoires. |
| UNICODE | Fixed 16-bit characters from the UNICODE 4.1 standard. |
| GRAPHIC | Fixed 16-bit UNICODE characters defined by IBM Corporation for DB2. |
| KANJI1 | Mixed single-byte/multi-byte characters as defined by KanjiEBCDIC, KanjiShift-JIS, or KanjiEUC, depending on the current Session Character Set. |
| KANJISJIS | Mixed single-byte/multi-byte characters intended for Japanese applications that rely on KanjiShiftJIS characteristics. |