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.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |