When importing entities from the databases, OutSystems Platform maps MySQL Server data types into OutSystems data types.

The map between the data types is specified in the following table:

MySQL Server data Types

OutSystems data types

BIGINT

Long Integer

BINARY

Binary Data

BLOB

Binary Data

CHAR

Text

DATE

Date

DATETIME

Date Time

DECIMAL

if the precision is lower than 38 -> Decimal,

otherwise -> Text

DOUBLE

if the precision is lower than 38 -> Decimal,

otherwise -> Text

ENUM

Text

FLOAT

if the precision is lower than 38 -> Decimal,

otherwise -> Text

INT

Integer

LONGBLOB

Binary Data

LONGTEXT

Text

MEDIUMBLOB

Binary Data

MEDIUMINT

Integer

MEDIUMTEXT

Text

SET

Text

SMALLINT

Integer

TEXT

Text

TIME

Time

TIMESTAMP

Date Time

TINYBLOB

Binary Data

TINYINT

if the precision is 1 -> Boolean,

otherwise -> Integer

TINYTEXT

Text

VARBINARY

Binary Data

VARCHAR

Text

YEAR

Integer

All other data types

Unsupported

See Also

Available Data Types | DB2 Data Types to OutSystems Data Types | Oracle Data Types to OutSystems Data Types | SQL Server Data Types to OutSystems Data Types