The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.

MySQL Data Types Mapping

XPO creates these column types when updating the MySQL database schema and expects them in existing databases.

.NET Type Database Column Type
Boolean bit
Byte tinyint unsigned
SByte tinyint
Char char
Decimal decimal(28,8)
Double double
Single real
Int16 smallint
UInt16 smallint unsigned
Int32 int
UInt32 int unsigned
Int64 bigint
UInt64 bigint unsigned
Guid char(38)
String varchar(N), TEXT, MEDIUMTEXT
DateTime in MySQL prior to 8.0, datetime; otherwise datetime(6)
TimeSpan double
Byte[] TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB
Unlimited size string LONGTEXT
See Also