A Data Type Conversion

This appendix contains the following section:

A.1 Data Type Conversion

The gateway converts Sybase data types to Oracle data types as follows:

Table A-1 Data Type Conversions

Sybase Oracle Comment

BINARY

RAW

-

BIT

NUMBER(3)

-

CHAR

CHAR

-

DATETIME

DATE

-

DECIMAL

NUMBER(18)

-

DOUBLE PRECISION

FLOAT(49)

-

FLOAT

FLOAT(49)

-

IMAGE

LONG RAW

-

INT

NUMBER(10)

NUMBER range is -2,147,483,647 to 2,147,483,647

MONEY

NUMBER(p[,s])

-

NCHAR

Not supported

-

NUMERIC

NUMBER(p[,s])

-

NVARCHAR

Not supported

-

REAL

FLOAT(23)

-

SMALLDATETIME

DATE

-

SMALLINT

NUMBER(5)

NUMBER range is -32,767 to 32,767

SMALL MONEY

NUMBER(p[,s])

-

TEXT

LONG

-

TINYINT

NUMBER(3)

-

VARBINARY

RAW

-

VARCHAR

VARCHAR2

-