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

Part Number B14278-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 Ingres II data types to Oracle data types as follows:

Table A-1 Data Type Conversions

Ingres II Oracle Comment
BYTE RAW -
BYTE VARYING RAW -
C, CHAR CHAR -
DATE DATE DATE range is January 1, 1582 through December 31, 2382.
DECIMAL NUMBER(p[,s]) If precision and scale are not specified, DECIMAL is converted to NUMBER(16)
FLOAT FLOAT(49) -
FLOAT4 FLOAT(23) -
FLOAT8 FLOAT(49) -
INTEGER NUMBER(10) NUMBER range is -2,147,483,647 to 2,147,483,647
INTEGER1 NUMBER(3) -
INTEGER2 NUMBER(5) NUMBER range is -32,767 to 32,767
INTEGER4 NUMBER(10) NUMBER range is -2,147,483,647 to 2,147,483,647
LONG BYTE LONG RAW -
LONG VARCHAR LONG -
MONEY FLOAT(49) -
OBJECT_KEY CHAR(16) -
SMALLINT NUMBER(5) NUMBER range is -32,767 to 32,767
TABLE_KEY CHAR(8) -
TEXT VARCHAR2 The length of a TEXT data type ranges from 1 to 2000 characters
VARCHAR VARCHAR2 The length of a VARCHAR data type ranges from 1 to 2000 characters