Data type mapping from MySQL to YugabyteDB

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, 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