Skip Headers
Oracle® Database Gateway for Informix User's Guide
11g Release 1 (11.1)

Part Number B31047-02
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
View PDF

A Data Type Conversion

This appendix contains the following section:

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

BLOB

LONG RAW

-

BOOLEAN

NUMBER(3)


BYTE

LONG RAW

-

CLOB

LONG

-

CHAR

CHAR

-

DATE

DATE

-

DATETIME YEAR TO DAY

DATE


DATETIME YEAR TO FRACTION

DATE


DATETIME YEAR TO SECOND

DATE


DATETIME HOUR TO SECOND

CHAR(15)


DATETIME HOUR TO FRACTION

CHAR(15)


DECIMAL

NUMBER(p[,s])

-

FLOAT

FLOAT(53)

-

INT8

NUMBER(19)


INTEGER

NUMBER(10)

NUMBER range is -2,147,483,647 to 2,147,483,647

INTERVAL YEAR() TO YEAR

INTERVAL YEAR TO MONTH


INTERVAL MONTH() TO MONTH

INTERVAL YEAR TO MONTH


INTERVAL YEAR() TO MONTH

INTERVAL YEAR TO MONTH


INTERVAL DAY() TO DAY

INTERVAL DAY TO SECOND


INTERVAL HOUR() TO HOUR

INTERVAL DAY TO SECOND


INTERVAL MINUTE() TO MINUTE

INTERVAL DAY TO SECOND


INTERVAL SECOND() TO SECOND

INTERVAL DAY TO SECOND


INTERVAL SECOND() TO FRACTION

INTERVAL DAY TO SECOND


INTERVAL FRACTION TO FRACTION

INTERVAL DAY TO SECOND


INTERVAL DAY() TO HOUR

INTERVAL DAY TO SECOND


INTERVAL DAY() TO MINUTE

INTERVAL DAY TO SECOND


INTERVAL DAY() TO SECOND

INTERVAL DAY TO SECOND


INTERVAL DAY() TO FRACTION

INTERVAL DAY TO SECOND


INTERVAL HOUR() TO MINUTE

INTERVAL DAY TO SECOND


INTERVAL HOUR() TO SECOND

INTERVAL DAY TO SECOND


INTERVAL HOUR() TO FRACTION

INTERVAL DAY TO SECOND


INTERVAL MINUTE() TO SECOND

INTERVAL DAY TO SECOND


INTERVAL MINUTE() TO FRACTION

INTERVAL DAY TO SECOND


LVARCHAR

VARCHAR2

-

MONEY

NUMBER(p[,s])

-

NCHAR

CHAR

-

NVARCHAR

VARCHAR2

-

SERIAL

NUMBER(10)

NUMBER range is -2,147,483,647 to 2,147,483,647

SERIAL8

NUMBER(19)

-

SMALLFLOAT

FLOAT(24)

Precision is 6

SMALLINT

NUMBER(5)


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.