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

Part Number B14275-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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

A Data Type Conversion

This appendix contains the following section:

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.