---
title: "Data type mapping from MySQL to YugabyteDB"
url: "https://docs.yugabyte.com/stable/yugabyte-voyager/reference/datatype-mapping-mysql/"
---

# Data type mapping from MySQL to YugabyteDB

Refer to the data type mapping table when migrating data from MySQL to YugabyteDB using YugabyteDB Voyager.

- [MySQL to YugabytyeDB](/stable/yugabyte-voyager/reference/datatype-mapping-mysql/)
- [Oracle to YugabyteDB](/stable/yugabyte-voyager/reference/datatype-mapping-oracle/)

The following table includes a list of supported data type mappings for migrating data from MySQL to YugabyteDB using YugabyteDB Voyager:

| MySQL data type      | Maps to YugabyteDB as      | Description                                                                                                                                                                                                                                                                                                            |
|----------------------|----------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| BINARY               | BYTEA                      |                                                                                                                                                                                                                                                                                                                        |
| VARBINARY            | BYTEA                      |                                                                                                                                                                                                                                                                                                                        |
| BIT                  | BIT                        |                                                                                                                                                                                                                                                                                                                        |
| BOOLEAN              | SMALLINT                   | As BOOLEAN type is a synonym of TINYINT(1) in [MySQL](https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html "MySQL"), it is converted to SMALLINT in YugabyteDB, but if your use case needs it to be converted to BOOLEAN in YugabyteDB, modify the schema manually for all the respective BOOLEAN columns. |
| CHAR                 | CHAR                       |                                                                                                                                                                                                                                                                                                                        |
| VARCHAR              | VARCHAR                    |                                                                                                                                                                                                                                                                                                                        |
| TINYTEXT             | TEXT                       |                                                                                                                                                                                                                                                                                                                        |
| MEDIUMTEXT           | TEXT                       |                                                                                                                                                                                                                                                                                                                        |
| TEXT                 | TEXT                       |                                                                                                                                                                                                                                                                                                                        |
| LONGTEXT             | TEXT                       |                                                                                                                                                                                                                                                                                                                        |
| TINYBLOB             | BYTEA                      | Data is ignored during export.                                                                                                                                                                                                                                                                                         |
| BLOB                 | BYTEA                      | Data is ignored during export.                                                                                                                                                                                                                                                                                         |
| MEDIUMBLOB           | BYTEA                      | Data is ignored during export.                                                                                                                                                                                                                                                                                         |
| LONGBLOB             | BYTEA                      | Data is ignored during export.                                                                                                                                                                                                                                                                                         |
| DATE                 | DATE                       |                                                                                                                                                                                                                                                                                                                        |
| TIME                 | TIME WITHOUT TIMEZONE      |                                                                                                                                                                                                                                                                                                                        |
| DATETIME             | TIMESTAMP WITHOUT TIMEZONE |                                                                                                                                                                                                                                                                                                                        |
| TIMESTAMP            | TIMESTAMP                  |                                                                                                                                                                                                                                                                                                                        |
| YEAR                 | SMALLINT                   |                                                                                                                                                                                                                                                                                                                        |
| DEC                  | DECIMAL                    |                                                                                                                                                                                                                                                                                                                        |
| DECIMAL              | DECIMAL                    |                                                                                                                                                                                                                                                                                                                        |
| NUMERIC              | DECIMAL                    |                                                                                                                                                                                                                                                                                                                        |
| FIXED                | DECIMAL                    |                                                                                                                                                                                                                                                                                                                        |
| ENUM                 | ENUM                       | A user-defined ENUM type is created                                                                                                                                                                                                                                                                                    |
| FLOAT                | DOUBLE PRECISION           |                                                                                                                                                                                                                                                                                                                        |
| REAL                 | DOUBLE PRECISION           |                                                                                                                                                                                                                                                                                                                        |
| DOUBLE               | DOUBLE PRECISION           |                                                                                                                                                                                                                                                                                                                        |
| JSON/JSONB           | JSON                       |                                                                                                                                                                                                                                                                                                                        |
| UUID                 | BYTEA                      | Not a separate datatype; it is created using functions.                                                                                                                                                                                                                                                                |
| TINYINT SIGNED       | SMALLINT                   |                                                                                                                                                                                                                                                                                                                        |
| TINYINT UNSIGNED     | SMALLINT                   |                                                                                                                                                                                                                                                                                                                        |
| SMALLINT SIGNED      | INTEGER                    |                                                                                                                                                                                                                                                                                                                        |
| SMALLINT UNSIGNED    | INTEGER                    |                                                                                                                                                                                                                                                                                                                        |
| MEDUIMINT SIGNED     | INTEGER                    |                                                                                                                                                                                                                                                                                                                        |
| MEDUIMINT UNSIGNED   | INTEGER                    |                                                                                                                                                                                                                                                                                                                        |
| INT/INTEGER SIGNED   | BIGINT                     |                                                                                                                                                                                                                                                                                                                        |
| INT/INTEGER UNSIGNED | BIGINT                     |                                                                                                                                                                                                                                                                                                                        |
| BIGINT SIGNED        | BIGINT                     |                                                                                                                                                                                                                                                                                                                        |
| BIGINT UNSIGNED      | NUMERIC(20)                |                                                                                                                                                                                                                                                                                                                        |

## Learn more

- [Data modeling](/stable/develop/data-modeling "Data modeling")