A Data Type Conversion

This appendix contains the following section:

Data Type Conversion

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(53)`	-
`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])`	-
`NCHAR`	Not supported	-
`NUMERIC`	`NUMBER(p[,s])`	-
`NVARCHAR`	Not supported	-
`REAL`	`FLOAT(24)`	-
`SMALLDATETIME`	`DATE`	-
`SMALLINT`	`NUMBER(5)`	`NUMBER` range is `-32,767` to `32,767`
`SMALL MONEY`	`NUMBER(p[,s])`	-
`TEXT`	`LONG`	-
`TINYINT`	`NUMBER(3)`	-
`UNICHAR`	`NCHAR`	-
`UNIVARCHAR`	`NVARCHAR`	-
`VARBINARY`	`RAW`	-
`VARCHAR`	`VARCHAR2`	-