Skip Headers
Oracle® Transparent Gateway for Teradata Administrator's Guide
10g Release 2 (10.2) for Solaris Operating System (SPARC)

Part Number B14280-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

A Data Type Conversion

This appendix contains the following section:

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)