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

Discuss this page in DocCommentXchange.
Send feedback about this page using email.