Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Server Classes for Remote Data Access » ODBC-based server classes » Server class oraodbc

Server class oraodbc Next Page

Data type conversions: Oracle

When you issue a CREATE TABLE statement, SQL Anywhere automatically converts the data types to the corresponding Oracle data types. The following table describes the SQL Anywhere to Oracle data type conversions.

SQL Anywhere data type Oracle data type
bit number(1,0)
tinyint number(3,0)
smallint number(5,0)
int number(11,0)
bigint number(20,0)
decimal(prec, scale) number(prec, scale)
numeric(prec, scale) number(prec, scale)
float float
real real
smallmoney numeric(13,4)
money number(19,4)
date date
time date
timestamp date
smalldatetime date
datetime date
char(n) if (n > 255) long else varchar(n)
varchar(n) if (n > 2000) long else varchar(n)
long varchar long or clob
binary(n) if (n > 255) long raw else raw(n)
varbinary(n) if (n > 255) long raw else raw(n)
long binary long raw