Skip Headers
Oracle® Transparent Gateway for Sybase Administrator's Guide
10g Release 2 (10.2) for IBM AIX

Part Number B14284-01
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:

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 -