Microsoft SQL Server class-level translations

The following sections list class-level translations for Microsoft SQL Server datatypes to datatypes of other supported non-Sybase data servers:

Class-level translations are not supplied for Adaptive Server datatypes to Microsoft SQL Server datatypes (or Microsoft SQL Server datatypes to Adaptive Server datatypes) because Microsoft SQL Server datatypes are directly compatible with Adaptive Server datatypes and they require no translation.

Microsoft SQL Server to DB2 datatypes

Table A-14 lists class-level translations from Microsoft SQL Server datatypes to DB2 datatypes.

**Table A-14: Class-level translation from Microsoft SQL Server to DB2 datatypes**
Microsoft SQL Server datatype	DB2 datatype
binary	CHAR FOR BIT DATA
bit	TINYINT
datetime	TIMESTAMP
decimal	DECIMAL
money	NUMERIC
numeric	NUMERIC
smalldatetime	TIMESTAMP
smallmoney	NUMERIC
varbinary	VARCHAR FOR BIT DATA

Microsoft SQL Server to Informix datatypes

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

**Table A-15: Class-level translation from Microsoft SQL Server to Informix datatypes**
Microsoft SQL Server datatype	Informix datatype
binary	binary
datetime	datetime fraction(3)
smalldatetime	datetime fraction(0)
varbinary	binary

Microsoft SQL Server to Oracle datatypes

Table A-16 lists class-level translations from Microsoft SQL Server datatypes to Oracle datatypes.

**Table A-16: Class-level translation from Microsoft SQL Server to Oracle datatypes**
Microsoft SQL Server datatype	Oracle datatype
binary	RAW
datetime	DATE (with time)
money	DECIMAL
smalldatetime	DATE
smallmoney	DECIMAL
varbinary	RAW