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
binary	binary
date	date
datetime	datetime fraction(3)
smalldatetime	datetime fraction(0)
time	datetime (time only)
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)