Skip Headers

Oracle® Transparent Gateway for Sybase Administrator's Guide
10g Release 1 (10.1) for Solaris Operating System (SPARC)

Part Number B10529-01
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

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

-


Go to previous page Go to next page
Oracle
Copyright © 2002, 2003 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents
Go To Index
Index