Adaptive Server to Oracle Datatypes

Lists class-level translations from Adaptive Server datatypes to Oracle datatypes.

Class-Level Translation from Adaptive Server to Oracle Datatypes

Adaptive Server Datatype

Oracle Datatype

bigdatetime

TIMESTAMP (9)

bigint

NUMBER

bigtime

TIMESTAMP (9)

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