Teradata DATATYPES , RANGE and STORAGE SPACE
Teradata supports so many datatypes for columns in table. Some of them are standard ANSI datatypes and some Teradata extension to SQL. Below is the list of few very common DATATYPES used in TERADATA with the range for acceptable values and storage space it requires.
DATATYPE | RANGE | SPACE (BYTE) | STANDARD |
NUMERIC | DECIMAL(m,n) n= 1 to 38 m= 0 to n | 1 TO 2 –> 1 3 TO 4 –> 2 5 TO 9 –> 4 10 TO 18 –> 8 19 TO 38 –> 16 | ANSI |
DECIMAL | DECIMAL(m,n) n= 1 to 38 m= 0 to n | 1 TO 2 –> 1 3 TO 4 –> 2 5 TO 9 –> 4 10 TO 18 –> 8 19 TO 38 –> 16 | TD |
REAL | 2.26*(10)^-308 TO 1.797*(10)^308 | 8 | ANSI |
DOUBLE PRECISION | 2.26*(10)^-308 TO 1.797*(10)^308 | 8 | ANSI |
FLOAT | 2.26*(10)^-308 TO 1.797*(10)^308 | 8 | TD |
BYTEINT | -128 TO 127 | 1 | TD |
SMALLINT | -32768 TO 32767 | 2 | ANSI |
INTEGER | -2147483648 TO 2147483647 | 4 | ANSI |
BIGINT | -9223372036854775808 TO 9223372036854775807 | 8 | ANSI |
DATE | 4 | ANSI | |
TIME | 6 | TD | |
TIMESTAMP | 10 | TD | |
TIME WITH TIME ZONE | 8 | ANSI | |
TIMESTAMP WITH TIME ZONE | 12 | ANSI | |
PERIOD DATE | 8 | TD | |
PERIOD TIME | 12 | TD | |
PERIOD TIME WITH TIME ZONE | 16 | TD | |
PERIOD TIMESTAMP | 20 | TD | |
PERIOD TIMESTAMP WITH TIME ZONE | 24 | TD | |
CHAR | 64000 | n where n is no of digits | ANSI |
VARCHAR | 64000 | n+2 where n is no of digits | ANSI |