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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Server classes for remote data access » ODBC-based server classes

 

Server class adsodbc

When you issue a CREATE TABLE statement, SQL Anywhere automatically converts the data types to the corresponding Advantage Database Server data types using the following data type conversions.

SQL Anywhere data type ADS default data type
BIT Logical
TINYINT, SMALLINT, INT, INTEGER Integer
BIGINT Numeric(32)
DECIMAL(p,s), NUMERIC(p,s) Numeric(p+3)
DATE Date
TIME Time
DATETIME, TIMESTAMP TimeStamp
MONEY, SMALLMONEY Money
FLOAT, REAL Double
CHAR(n), VARCHAR(n), LONG VARCHAR Char(n)
BINARY(n), VARBINARY(n), LONG BINARY Blob