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