The following sections list class-level translations for Microsoft SQL Server datatypes to datatypes of other supported non-ASE data servers.
Table A-7 lists class-level translations from Adaptive Server datatypes to Microsoft SQL Server datatypes for the unsigned datatypes.
The remaining 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.
Adaptive Server datatype |
Microsoft SQL Server datatype |
---|---|
unsigned bigint |
DECIMAL (20,0) |
unsigned int |
BIGINT |
unsigned smallint |
INT |
unsigned tinyint |
SMALLINT |
unitext |
NTEXT |
Table A-8 lists class-level translations from Microsoft SQL Server datatypes 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 |
Table A-9 lists class-level translations from Microsoft SQL Server datatypes to Oracle datatypes.
Microsoft SQL Server datatype |
Oracle datatype |
---|---|
binary |
RAW |
datetime |
DATE (with time) |
money |
DECIMAL |
smalldatetime |
DATE |
smallmoney |
DECIMAL |
varbinary |
RAW |