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)	-
`CHAR`	`CHAR`	-
`CHAR CHARACTER SET UNICO`	`CHAR`
`CLOB`	`LONG`
`DATE`	`DATE`	-
`DECIMAL`	`NUMBER(p[,s])`	-
`DECIMAL`	`NUMBER(19)`	-
`FLOAT`	`FLOAT(24)`	with precision <= single precision float
`FLOAT`	`FLOAT(53)`	-
`INTEGER`	`NUMBER(10)`	`NUMBER` range is `-2,147,483,647` to `2,147,483,647`
`INTERVAL YEAR`	`INTERVAL YEAR TO MONTH`	-
`INTERVAL MONTH`	`INTERVAL YEAR TO MONTH`	-
`INTERVAL YEAR TO MONTH`	`INTERVAL YEAR TO MONTH`	-
`INTERVAL DAY`	`INTERVAL DAY TO SECOND`	-
`INTERVAL HOUR`	`INTERVAL DAY TO SECOND`	-
`INTERVAL MINUTE`	`INTERVAL DAY TO SECOND`	-
`INTERVAL SECOND`	`INTERVAL DAY TO SECOND`	-
`INTERVAL DAY TO HOUR`	`INTERVAL DAY TO SECOND`	-
`INTERVAL DAY TO MINUTE`	`INTERVAL DAY TO SECOND`	-
`INTERVAL DAY TO SECOND`	`INTERVAL DAY TO SECOND`	-
`INTERVAL HOUR TO MINUTE`	`INTERVAL DAY TO SECOND`	-
`INTERVAL HOUR TO SECOND`	`INTERVAL DAY TO SECOND`	-
`INTERVAL MINUTE TO SECOND`	`INTERVAL DAY TO SECOND`	-
`LONG` `VARCHAR` `CHARACTER SET UNICO`	`LONG`	-
`LONG` `VARCHAR`	`LONG`	-
`SMALLINT`	`NUMBER(5)`	-
`TIME`	`CHAR(15)`	-
`TIMESTAMP`	`TIMESTAMP`	-
`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's mapped to `LONG`
`VARCHAR() CHARACTER SET UNICO`	`VARCHAR2`	-