A Data Type Conversion

This appendix contains the following section:

• Data Type Conversion

A.1 Data Type Conversion

The gateway converts Teradata data types to Oracle data types as follows:

Table A-1 Data Type Conversions

Teradata	Oracle	Comment
BYTE	RAW	-
BYTEINT	NUMBER(3)	-
CHAR	CHAR	-
CHARACTER	CHAR	-
DATE	CHAR(10) or DATE	The conversion depends on the DateTimeFormat parameter in the ODBC DSN. Please refer to NCR's ODBC documentation
DEC	NUMBER(p[,s])	-
DECIMAL	NUMBER(p[,s])	-
DOUBLE PRECISION	FLOAT(49)	-
FLOAT	FLOAT(49)	-
INT	NUMBER(10)	NUMBER range is -2,147,483,647 to 2,147,483,647
INTEGER	NUMBER(10)	NUMBER range is -2,147,483,647 to 2,147,483,647
INTERVAL	Not supported	-
LONG VARCHAR	LONG	-
NUMERIC	NUMBER(p[,s])	-
REAL	FLOAT(49)	-
SMALLINT	NUMBER(5)	-
TIME	CHAR(8) or DATE	The conversion depends on the DateTimeFormat parameter in the ODBC DSN. Please refer to NCR's ODBC documentation
TIMESTAMP	CHAR(23) or DATE	The conversion depends on the DateTimeFormat parameter in the ODBC DSN. Please refer to NCR's ODBC documentation
VARBYTE	RAW	VARBYTE is right padded. If the size is greater than 2000 it is truncated to RAW(2000)
VARCHAR	VARCHAR2	If the size is greater than 4000 it is truncated to VARCHAR2(4000)