For Generic Coding with the ADO.NET 2.0 Base Classes and Factories
.NET Framework type |
DbType |
MySqlDbType |
MySQL Server data type |
|
|
AnsiStringFixedLength
StringFixedLength |
String | CHAR | |
AnsiString | VarChar | VARCHAR | ||
String | String | |||
Date | Date | DATE | ||
DateTime | DateTime | DateTime | DATETIME | |
NewDecimal (MySQL 5.0.3 or greater)
|
NUMERIC
DECIMAL DEC FIXED |
|||
Decimal | Decimal | Decimal | ||
Currency | ||||
Year | YEAR | |||
TimeSpan | Time | Time | TIME | |
Timestamp | TIMESTAMP | |||
Set | SET | |||
Enum | ENUM | |||
Boolean | UByte | TINYINT | ||
Boolean
Byte |
Byte | |||
SByte | SByte | Byte | ||
BOOL
BOOLEAN |
||||
UInt16 or Int16 | UInt16 or Int16 | UInt16 or Int16 | SMALLINT | |
UInt24 or Int24 | MEDIUMINT | |||
UInt32 or Int32 | UInt32 or Int32 | UInt32 or Int32 | INT
INTEGER |
|
UInt64 | UInt64 | UInt64 | SERIAL | |
BIGINT | ||||
Int64 | Int64 | Int64 | ||
Single | Single | Float | FLOAT | |
REAL | ||||
Double | Double | Double | ||
DOUBLE | ||||
Text | TEXT | |||
Object | Object | Blob | BLOB | |
VarNumeric | ||||
Binary | ||||
LongBlob | LONGBLOB | |||
LongText | LONGTEXT | |||
MediumBlob | MEDIUMBLOB | |||
MediumText | MEDIUMTEXT | |||
TinyBlob | TINYBLOB | |||
TinyText | TINYTEXT | |||
Binary | BINARY | |||
VarBinary | VARBINARY |
Used sources
NameToType in mysql-connector-net-6.4.3-srcSourceMySql.DataTypesMetaData.cs
SetDbType, SetMySqlDbType and SetTypeFromValue in mysql-connector-net-6.4.3-srcSourceMySql.Dataparameter.cs