Skip Headers
Oracle® Transparent Gateway for Rdb Administrator's Guide
10g Release 1 (10.1) for HP OpenVMS
Part No. B10537-01
  Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

A Data Type Conversion

This appendix contains the following section:

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 -