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 -