Specifies MySQL specific data type of a field, property, for use in a MySql.Data.MySqlClient.MySqlParameter. [Edit]

public enum MySqlDbType

Remarks

Documentation for this section has not yet been entered. [Edit]

Members

Member Name	Description
Binary	Fixed length binary string. [Edit]
Bit	Bit-field data type [Edit]
Blob	A binary column with a maximum length of 65535 (2^16 - 1) bytes. [Edit]
Byte	byte The signed range is -128 to 127. The unsigned range is 0 to 255. [Edit]
Date	Date The supported range is '1000-01-01' to '9999-12-31'. [Edit]
Datetime	Datetime The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. [Edit]
DateTime	DateTime The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. [Edit]
Decimal	decimal A fixed precision and scale numeric value between -1038 -1 and 10 38 -1. [Edit]
Double	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. [Edit]
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 [Edit]
Float	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. [Edit]
Geometry	Geometric (GIS) data type. [Edit]
Guid	A guid column [Edit]
Int16	short A 16-bit signed integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535 [Edit]
Int24	Specifies a 24 (3 byte) signed or unsigned value. [Edit]
Int32	int A 32-bit signed integer [Edit]
Int64	long A 64-bit signed integer. [Edit]
LongBlob	A binary column with a maximum length of 4294967295 or 4G (2^32 - 1) bytes. [Edit]
LongText	A text column with a maximum length of 4294967295 or 4G (2^32 - 1) characters. [Edit]
MediumBlob	A binary column with a maximum length of 16777215 (2^24 - 1) bytes. [Edit]
MediumText	A text column with a maximum length of 16777215 (2^24 - 1) characters. [Edit]
Newdate	Obsolete Use Datetime or Date type [Edit]
NewDecimal	New Decimal [Edit]
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. [Edit]
String	A fixed-length string. [Edit]
Text	A text column with a maximum length of 65535 (2^16 - 1) characters. [Edit]
Time	The range is '-838:59:59' to '838:59:59'. [Edit]
Timestamp	A timestamp. The range is '1970-01-01 00:00:00' to sometime in the year 2037 [Edit]
TinyBlob	A binary column with a maximum length of 255 (2^8 - 1) characters [Edit]
TinyText	A text column with a maximum length of 255 (2^8 - 1) characters. [Edit]
UByte	Unsigned 8-bit value. [Edit]
UInt16	Unsigned 16-bit value. [Edit]
UInt24	Unsigned 24-bit value. [Edit]
UInt32	Unsigned 32-bit value. [Edit]
UInt64	Unsigned 64-bit value. [Edit]
VarBinary	Variable length binary string. [Edit]
VarChar	A variable-length string containing 0 to 255 bytes. [Edit]
VarString	A variable-length string containing 0 to 65535 characters [Edit]
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). [Edit]

Requirements

Namespace: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll)
Assembly Versions: 6.1.3.0