A Data Type Conversion

This appendix contains the following section:

Data Type Conversion

A.1 Data Type Conversion

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

Table A-1 Data Type Conversions

Informix	Oracle	Comment
BYTE	LONG RAW	-
CHAR	CHAR	-
DATE	DATE	-
DATETIME	DATE	-
DECIMAL	FLOAT(49)	-
DOUBLE PRECISION	FLOAT(49)	-
FLOAT	FLOAT(49)	-
INTEGER	NUMBER(10)	NUMBER range is -2,147,483,647 to 2,147,483,647
INTERVAL	VARCHAR2(17)	-
MONEY	NUMBER(p[,s])	-
NCHAR	Not supported	-
NUMERIC	NUMBER(p[,s])	-
NVARCHAR	Not supported	-
REAL	FLOAT(23)	Precision is 6
SERIAL	NUMBER(10)	NUMBER range is -2,147,483,647 to 2,147,483,647
SMALLFLOAT	FLOAT(23)	Precision is 6
SMALLINT	NUMBER(5)	NUMBER range is -32,767 to 32,767
TEXT	LONG	-
VARCHAR	VARCHAR2	If a length is not specified as part of VARCHAR, the data type is converted to VARCHAR2(1)

In addition to the rules shown in the preceding table, if the maximum size for an Informix data type is smaller or larger than the corresponding Oracle data type, data might be lost. For example, if an Oracle table is defined with a column of VARCHAR2(300) and you use the COPY statement to copy the Oracle table to the Informix table where the Informix column is defined as VARCHAR(255), the data might be truncated.