When you execute 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) |
| VARBIT(n) | if (n <= 4000) varbinary(n) else longblob |
| LONG VARBIT | longblob |
| TINYINT | tinyint unsigned |
| SMALLINT | smallint |
| INTEGER | int |
| BIGINT | bigint |
| UNSIGNED TINYINT | tinyint unsigned |
| UNSIGNED SMALLINT | int |
| UNSIGNED INTEGER | bigint |
| UNSIGNED BIGINT | decimal(20,0) |
| CHAR(n) | if (n < 255) char(n) else if (n <= 4000) varchar(n) else longtext |
| VARCHAR(n) | if (n <= 4000) varchar(n) else longtext |
| LONG VARCHAR | longtext |
| NCHAR(n) | if (n < 255) national character(n) else if (n <= 4000) national character varying(n) else longtext |
| NVARCHAR(n) | if (n <= 4000) national character varying(n) else longtext |
| LONG NVARCHAR | longtext |
| BINARY(n) | if (n <= 4000) varbinary(n) else longblob |
| VARBINARY(n) | if (n <= 4000) varbinary(n) else longblob |
| LONG BINARY | longblob |
| DECIMAL(precision, scale) | decimal(precision, scale) |
| NUMERIC(precision, scale) | decimal(precision, scale) |
| SMALLMONEY | decimal(10,4) |
| MONEY | decimal(19,4) |
| REAL | real |
| DOUBLE | float |
| FLOAT(n) | float(n) |
| DATE | date |
| TIME | time |
| TIMESTAMP | datetime |
| TIMESTAMP WITH TIMEZONE | varchar(254) |
| XML | longblob |
| ST_GEOMETRY | longblob |
| UNIQUEIDENTIFIER | varbinary(16) |
Example |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |