Skip Headers
Oracle® Database Gateway for Sybase User's Guide
11g Release 2 (11.2)

Part Number E12067-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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

BIGINT

NUMBER(19)

 

BINARY

RAW

-

BIT

NUMBER(3)

-

CHAR

CHAR

-

DATE

DATE

 

DATETIME

DATE

-

DECIMAL

NUMBER(p[,s])

-

FLOAT

FLOAT(53)

-

IMAGE

LONG RAW

-

INT

NUMBER(10)

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

MONEY

NUMBER(p[,s])

-

NUMERIC

NUMBER(p[,s])

-

REAL

FLOAT(24)

-

SMALLDATETIME

DATE

-

SMALLINT

NUMBER(5)

NUMBER range is -32,767 to 32,767

SMALLMONEY

NUMBER(p[,s])

-

SYSNAME

VARCHAR2

 

TEXT

LONG

-

TIME

CHAR(15)

 

TIMESTAMP

RAW

 

TINYINT

NUMBER(3)

-

UNICHAR

NCHAR

-

UNSIGNED BIGINT

NUMBER(20)

 

UNSIGNED INT

NUMBER(10)

 

UNSIGNED SMALLINT

NUMBER(5)

 

UNITEXT

LONG

if Oracle DB Character Set = Unicode. Otherwise, it is not supported

UNIVARCHAR

NVARCHAR

-

VARBINARY

RAW

-

VARCHAR

VARCHAR2

-