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