A Data Type Conversion

This appendix contains the following section:

Data Type Conversion

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	-