Informix class-level translations

The following sections list class-level translations for Adaptive Server datatypes to Informix datatypes, Informix datatypes to Adaptive Server datatypes, and Informix datatypes to datatypes of other supported non-Sybase data servers:

Adaptive Server to Informix datatypes

Table A-8 lists class-level translations from Adaptive Server datatypes to Informix datatypes.

**Table A-8: Class-level translation from Adaptive Server to Informix datatypes**
Adaptive Server datatype	Informix datatype
bigint	int8 The bigint datatype is not compatible with many older versions of database servers. If the mapping described is not available in the version of the data server you are using, bigint can be mapped to the ANSI standard datatype of decimal (19,0).
binary	binary
date	date
datetime	datetime fraction(3)
smalldatetime	datetime fraction(0)
time	datetime (time only)
unsigned tinyint	smallint
unsigned smallint	integer
unsigned int	int8
unsigned bigint	decimal(20,0)
unitext	CLOB
varbinary	binary

Informix to Adaptive Server datatypes

Table A-9 lists class-level translations from Informix datatypes to Adaptive Server datatypes.

**Table A-9: Class-level translation from Informix to Adaptive Server datatypes**
Informix datatype	Adaptive Server datatype
binary	binary
date	datetime
datetime fraction(0)	datetime
datetime fraction(1)	datetime
datetime fraction(2)	datetime
datetime fraction(3)	datetime
datetime fraction(4)	datetime
datetime fraction(5)	datetime
datetime (time only)	datetime

Informix to DB2 Datatypes

Table A-10 lists class-level translations from Informix datatypes to DB2 datatypes.

**Table A-10: Class-level translation from Informix to DB2 datatypes**
Informix datatype	DB2 datatype
binary	CHAR FOR BIT DATA
date	DATE
datetime fraction(0)	TIMESTAMP
datetime fraction(1)	TIMESTAMP
datetime fraction(2)	TIMESTAMP
datetime fraction(3)	TIMESTAMP
datetime fraction(4)	TIMESTAMP
datetime fraction(5)	TIMESTAMP
datetime (time only)	TIME

Informix to Microsoft SQL Server datatypes

Table A-11 lists class-level translations from Informix datatypes to Microsoft SQL Server datatypes.

**Table A-11: Class-level translation from Informix to Microsoft SQL Server datatypes**
Informix datatype	Microsoft SQL Server datatype
binary	binary
date	datetime
datetime fraction(0)	datetime
datetime fraction(1)	datetime
datetime fraction(2)	datetime
datetime fraction(3)	datetime
datetime fraction(4)	datetime
datetime fraction(5)	datetime
datetime (time only)	datetime

Informix to Oracle datatypes

Table A-12 lists class-level translations from Informix datatypes to Oracle datatypes.

**Table A-12: Class-level translation from Informix to Oracle datatypes**
Informix datatype	Oracle datatype
binary	RAW
date	DATE
datetime fraction(0)	DATE (with time)
datetime fraction(1)	DATE (with time)
datetime fraction(2)	DATE (with time)
datetime fraction(3)	DATE (with time)
datetime fraction(4)	DATE (with time)
datetime fraction(5)	DATE (with time)
datetime (time only)	DATE (with time)