Skip Headers
Oracle® Database Gateway for Teradata User's Guide
11g Release 2 (11.2)

Part Number E12068-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
Contact Us

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

BLOB

LONG RAW

 

BYTE

RAW

-

BYTEINT

NUMBER(3)

BYTEINT range is -128 to +127

CHAR

CHAR

-

CHAR CHARACTER SET UNICO

CHAR

 

CLOB

LONG

 

DATE

CHAR(10)

-

DECIMAL

NUMBER(p[,s])

-

FLOAT

FLOAT(24)

with precision <= single precision float

FLOAT

FLOAT(53)

with precision > single precision float

INTEGER

NUMBER(10)

NUMBER range is -2,147,483,648 to 2,147,483,647

INTERVAL

CHAR

-

LONG VARCHAR CHARACTER SET UNICO

LONG

-

LONG VARCHAR

LONG

-

SMALLINT

NUMBER(5)

NUMBER range is -32768 to 32767

TIME

CHAR(15)

-

TIMESTAMP

DATE

-

VARBYTE

RAW

with less or equal to 2000 bytes

VARBYTE

LONG RAW

with more than 2000 bytes

VARCHAR

VARCHAR2

If the size is greater than 4000, it is mapped to LONG

VARCHAR() CHARACTER SET UNICO

NVARCHAR2

If the size is 2000 or less, otherwise it is mapped to LONG