The following sections list class-level translations for Adaptive Server datatypes to Oracle datatypes, Oracle datatypes to Adaptive Server datatypes, and Oracle datatypes to datatypes of other supported non-Sybase data servers:
Table A-19 lists class-level translations from Adaptive Server datatypes to Oracle datatypes.
Adaptive Server datatype |
Oracle datatype |
---|---|
bigint |
NUMBER |
binary |
RAW |
date |
DATE |
datetime |
DATE (with time) |
money |
DECIMAL |
smalldatetime |
DATE |
smallmoney |
DECIMAL |
time |
DATE (with time) |
unsigned tinyint |
SMALLINT |
unsigned smallint |
INTEGER |
unsigned int |
NUMBER |
unsigned bigint |
NUMBER |
unitext |
NCLOB |
varbinary |
RAW |
Table A-20 lists class-level translations from Oracle datatypes to Adaptive Server datatypes.
Oracle datatype |
Adaptive Server datatype |
---|---|
RAW |
varbinary |
DATE |
datetime |
TIMESTAMP (0) |
datetime |
TIMESTAMP (1) |
datetime |
TIMESTAMP (2) |
datetime |
TIMESTAMP (3) |
datetime |
TIMESTAMP (4) |
datetime |
TIMESTAMP (5) |
datetime |
TIMESTAMP (6) |
datetime |
TIMESTAMP (7) |
datetime |
TIMESTAMP (8) |
datetime |
TIMESTAMP (9) |
datetime |
Table A-21 lists class-level translations from Oracle datatypes to DB2 datatypes.
Oracle datatype |
DB2 datatype |
---|---|
RAW |
CHAR FOR BIT DATA |
DATE |
DATE |
DATE (with time) |
TIMESTAMP |
FLOAT |
DOUBLE (UNIX and Windows only) |
INTEGER |
INTEGER (UNIX and Windows only) |
TIMESTAMP (0) |
TIMESTAMP (UNIX and Windows only) |
TIMESTAMP (1) |
TIMESTAMP (UNIX and Windows only) |
TIMESTAMP (2) |
TIMESTAMP (UNIX and Windows only) |
TIMESTAMP (3) |
TIMESTAMP (UNIX and Windows only) |
TIMESTAMP (4) |
TIMESTAMP (UNIX and Windows only) |
TIMESTAMP (5) |
TIMESTAMP (UNIX and Windows only) |
TIMESTAMP (6) |
TIMESTAMP (UNIX and Windows only) |
TIMESTAMP (7) |
TIMESTAMP (UNIX and Windows only) |
TIMESTAMP (8) |
TIMESTAMP (UNIX and Windows only) |
TIMESTAMP (9) |
TIMESTAMP (UNIX and Windows only) |
Table A-22 lists class-level translations from Oracle datatypes to Informix datatypes.
Oracle datatype |
Informix datatype |
---|---|
RAW |
binary |
DATE |
date |
DATE (with time) |
datetime fraction(0) |
TIMESTAMP (0) |
datetime fraction(0) |
TIMESTAMP (1) |
datetime fraction(1) |
TIMESTAMP (2) |
datetime fraction(2) |
TIMESTAMP (3) |
datetime fraction(3) |
TIMESTAMP (4) |
datetime fraction(4) |
TIMESTAMP (5) |
datetime fraction(5) |
TIMESTAMP (6) |
datetime fraction(5) |
TIMESTAMP (7) |
datetime fraction(5) |
TIMESTAMP (8) |
datetime fraction(5) |
TIMESTAMP (9) |
datetime fraction(5) |
Table A-23 lists class-level translations from Oracle datatypes to Microsoft SQL Server datatypes.
Oracle datatype |
Microsoft SQL Server datatype |
---|---|
RAW |
varbinary |
DATE |
datetime |
TIMESTAMP (0) |
datetime |
TIMESTAMP (1) |
datetime |
TIMESTAMP (2) |
datetime |
TIMESTAMP (3) |
datetime |
TIMESTAMP (4) |
datetime |
TIMESTAMP (5) |
datetime |
TIMESTAMP (6) |
datetime |
TIMESTAMP (7) |
datetime |
TIMESTAMP (8) |
datetime |
TIMESTAMP (9) |
datetime |