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 mysqlodbc

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

SQL Anywhere data type MySQL default data type
BIT bit(1)
TINYINT tinyint unsigned
SMALLINT smallint
INT, INTEGER int
BIGINT bigint
DECIMAL(p,s), NUMERIC(p,s) decimal(p,s)
DATE date
TIME time
DATETIME, TIMESTAMP datetime
MONEY decimal(19,4)
SMALLMONEY decimal(10,4)
FLOAT float
REAL real
CHAR(n)

char(n) if n is less than 254

varchar(n) if n is greater than or equal to 254 but less than 4000

longtext if n is greater than or equal to 4000

VARCHAR(n)

varchar(n) if n is less than 4000

longtext if n is greater than or equal to 4000

LONG VARCHAR longtext
BINARY(n), VARBINARY(n)

varbinary(n) if n is less than 4000

longblob if n is greater than or equal to 4000

LONG BINARY longblob