MySqlDbType Enumeration
Specifies MySQL-specific data type of a field, property, for use in a MySqlParameter.
Syntax: Visual Basic
Public Enum MySqlDbType
Syntax: C#
public enum MySqlDbType
Members
| Member Name | Description |
| Newdate | Obsolete. Use Datetime or Date type. |
| Timestamp | A timestamp. The range is '1970-01-01 00:00:01.000000' to '2038-01-19 03:14:07.999999'. (Fractional seconds can only be stored with a MariaDB 5.6.4 or higher database server.) |
| Time | The range is '-838:59:59.000000' to '838:59:59.000000'. (Fractional seconds can only be stored with a MariaDB 5.6.4 or higher database server.) |
| Date | The supported range is '1000-01-01' to '9999-12-31'. |
| Datetime | The supported range is '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999'. (Fractional seconds can only be stored with a MariaDB 5.6.4 or higher database server.) |
| Year | A year in 2- or 4-digit format (default is 4-digit). The allowable values are 1901 to 2155, 0000 in the 4-digit year format, and 1970-2069 if you use the 2-digit format (70-69). |
| TinyBlob | A BLOB column with a maximum length of 255 (2^8 - 1) characters. |
| Blob | A BLOB column with a maximum length of 65535 (2^16 - 1) characters. |
| MediumBlob | A BLOB column with a maximum length of 16777215 (2^24 - 1) characters. |
| LongBlob | A BLOB column with a maximum length of 4294967295 or 4G (2^32 - 1) characters. |
| Int16 | A 16-bit signed integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535. |
| Int24 | Specifies a 24 (3 byte) signed or unsigned value. |
| Int32 | A 32-bit signed integer. |
| Int64 | A 64-bit signed integer. |
| Byte | The signed range is -128 to 127. The unsigned range is 0 to 255. |
| Float | A small (single-precision) floating-point number. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38. |
| Double | A normal-size (double-precision) floating-point number. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308. |
| UByte | An 8-bit unsigned value. |
| UInt16 | A 16-bit unsigned value. |
| UInt24 | A 24-bit unsigned value. |
| UInt32 | A 32-bit unsigned value. |
| UInt64 | A 64-bit unsigned value. |
| Decimal | A fixed precision and scale numeric value between -10^38-1 and 10^38-1. |
| NewDecimal | New Decimal |
| Set | A set. A string object that can have zero or more values, each of which must be chosen from the list of values 'value1', 'value2', ... A SET can have a maximum of 64 members. |
| String | Obsolete. Use VarChar type. |
| VarChar | A variable-length string containing 0 to 255 characters. |
| VarString | A variable-length string containing 0 to 65535 characters. |
| Enum | An enumeration. A string object that can have only one value, chosen from the list of values 'value1', 'value2', ..., NULL or the special '' error value. An ENUM can have a maximum of 65535 distinct values. |
| Geometry | |
| Bit | Bit-field data type. |
| TinyText | A nonbinary string column supporting a maximum length of 255 (2^8 - 1) characters. |
| Text | A nonbinary string column supporting a maximum length of 65535 (2^16 - 1) characters. |
| MediumText | A nonbinary string column supporting a maximum length of 16777215 (2^24 - 1) characters. |
| LongText | A nonbinary string column supporting a maximum length of 4294967295 (2^32 - 1) characters. |
Requirements
Namespace: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll)
See Also
MySql.Data.MySqlClient Namespace