When you issue a CREATE TABLE statement, the database server automatically converts the data types to the corresponding MySQL data types using the following data type conversions.
| SAP Sybase IQ 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 |