A Data Type Conversion

This appendix contains the following section:

Data Type Conversion

Data Type Conversion

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

Table A-1 Data Type Conversions

Rdb	Oracle	Comment
`BIGINT`	`NUMBER(19)`	-
`BIGINT(s)`	`NUMBER(19,s)`	-
`CHAR`	`CHAR`	-
`DATE VMS`	`DATE`	-
`DECIMAL`	`NUMBER`	-
`DOUBLE PRECISION`	`FLOAT(49)`	-
`FLOAT`	`FLOAT(49)`	-
`INTEGER`	`NUMBER(10)`	NUMBER range is -2,147,483,647 to 2,147,483,647
`INTEGER(s)`	`NUMBER(10,s)`	-
`INTERVAL`	`CHAR(24)`	-
`LIST OF BYTE VARYING`	`LONG RAW`	Segmented strings
`LONG VARCHAR`	`LONG`	-
`NUMERIC`	`NUMBER`	-
`REAL`	`FLOAT(23)`	-
`SMALLINT`	`NUMBER(5)`	NUMBER range is -32,767 to 32,767
`SMALLINT(s)`	`NUMBER(5,s)`	-
`TIME`	`DATE`	-
`TIMESTAMP`	`DATE`	-
`TINYINT`	`NUMBER(3)`	-
`TINYINT(s)`	`NUMBER(3,s)`	-
`VARCHAR`	`VARCHAR2`	-