The data types of different databases do not have one-to-one correspondence. During initial schema synchronization, Data Transmission Service (DTS) maps the data types of the source database to those of the destination database. The following tables list the data type mappings for you to view and evaluate the impact of data synchronization on your business.
Data synchronization from MySQL, ApsaraDB RDS for MySQL, or PolarDB for MySQL to AnalyticDB for MySQL
| MySQL data type | AnalyticDB for MySQL data type |
|---|---|
| bigint unsigned | decimal(20,0)
Note AnalyticDB for MySQL V3.0 has limits on the bigint data type. If an AUTO_INCREMENT
field in the source MySQL database uses the bigint data type, the data type remains
unchanged after this field is synchronized to the destination instance.
|
| binary | VARBINARY |
| bit | VARCHAR |
| blob | VARBINARY |
| char | varchar |
| date | DATE |
| datetime | DATETIME |
| decimal | decimal |
| double | double |
| enum | VARCHAR |
| FLOAT | FLOAT |
| geometry | VARBINARY |
| geometrycollection | VARBINARY |
| int unsigned | BIGINT |
| integer | int |
| json | JSON |
| linestring | VARBINARY |
| LONGBLOB | VARBINARY |
| LONGTEXT | varchar |
| MEDIUMBLOB | VARBINARY |
| mediumint | int |
| mediumint unsigned | INT |
| MEDIUMTEXT | varchar |
| multilinestring | VARBINARY |
| multipoint | VARBINARY |
| multipolygon | VARBINARY |
| numberic | DECIMAL |
| point | VARBINARY |
| polygon | VARBINARY |
| set | VARCHAR |
| smallint unsigned | INT |
| text | VARCHAR |
| time | TIME |
| timestamp | TIMESTAMP |
| TINYBLOB | VARBINARY |
| tinyint unsigned | SMALLINT |
| TINYTEXT | varchar |
| VARBINARY | VARBINARY |
| varchar | varchar |
| year | INT |
Data synchronization from MySQL, ApsaraDB RDS for MySQL, or PolarDB for MySQL to Elasticsearch
| MySQL data type | Elasticsearch data type | Description |
|---|---|---|
| BIGINT | LONG | None |
| BINARY | BINARY | None |
| BIT | LONG | If the data is only one byte long, we recommend that you use the BOOLEAN data type in Elasticsearch. |
| BLOB | BINARY | None |
| BOOL/BOOLEAN | BOOLEAN | None |
| CHAR | TEXT | None |
| DATE | DATE | The DATE format is yyyy-MM-dd, in UTC. For more information, see Date format mappings. |
| DATETIME | DATE | The DATE format is yyyy-MM-dd'T'HH:mm:ss, in UTC. If DATE is accurate to microseconds, its format is yyyy-MM-dd'T'HH:mm:ss.S. For more information, see Date format mappings. |
| DECIMAL/DEC | DOUBLE | If the DECIMAL value contains a decimal point, we recommend that you use the TEXT data type in Elasticsearch to ensure data consistency. |
| DOUBLE | DOUBLE | None |
| FLOAT | FLOAT | None |
| GEOMETRY | GEO_SHAPE | None |
| GEOMETRYCOLLECTION | GEO_SHAPE | None |
| INT | INTEGER | If the data type of the source database is UNSIGNED INT, we recommend that you use the LONG data type in Elasticsearch. |
| JSON | OBJECT | If the data is only one byte long, we recommend that you use the BOOLEAN data type in Elasticsearch. |
| LINESTRING | GEO_SHAPE | None |
| LONGTEXT | TEXT | None |
| MEDIUMINT | INTEGER | None |
| MEDIUMTEXT | TEXT | None |
| MULTILINESTRING | GEO_SHAPE | None |
| MULTIPOINT | GEO_SHAPE | If the data is only one byte long, we recommend that you use the BOOLEAN data type in Elasticsearch. |
| MULTIPOLYGON | GEO_SHAPE | None |
| POINT | GEO_POINT | None |
| POLYGON | GEO_SHAPE | None |
| REAL | DOUBLE | None |
| SMALLINT | SHORT | If the data type of the source database is UNSIGNED SMALLINT, we recommend that you use the INTEGER data type in Elasticsearch. |
| TIME | DATE | The DATE format is HH:mm:ss, in UTC. If DATE is accurate to microseconds, its format is HH:mm:ss.S. For more information, see Date format mappings. |
| TIMESTAMP | DATE | The DATE format is yyyy-MM-dd'T'HH:mm:ss, in UTC. If DATE is accurate to microseconds, its format is yyyy-MM-dd'T'HH:mm:ss.S. For more information, see Date format mappings. |
| TINYINT | SHORT | If the data type of the source database is UNSIGNED TINYINT, we recommend that you use the INTEGER data type in Elasticsearch. |
| TINYTEXT | TEXT | None |
| VARCHAR | TEXT | None |
| YEAR | DATE | The DATE format is yyyy, in UTC. For more information, see Date format mappings. |