MySqlDbType Enumeration

MySQL Connector.Net

previous page next page
Collapse image Expand Image Copy image CopyHover image
Specifies MySQL specific data type of a field, property, for use in a MySqlParameter.

Namespace: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll) Version: 6.8.4.0

Syntax

C# 
public enum MySqlDbType
Visual Basic 
Public Enumeration MySqlDbType
Visual C++ 
public enum class MySqlDbType

Members

Member name Value Description
Decimal 0 Decimal

A fixed precision and scale numeric value between -1038 -1 and 10 38 -1.
Byte 1 Byte

The signed range is -128 to 127. The unsigned range is 0 to 255.
Int16 2 Int16

A 16-bit signed integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535
Int24 9 Specifies a 24 (3 byte) signed or unsigned value.
Int32 3 Int32

A 32-bit signed integer
Int64 8 Int64

A 64-bit signed integer.
Float 4 Single

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 5 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.
Timestamp 7 A timestamp. The range is '1970-01-01 00:00:00' to sometime in the year 2037
Date 10 Date The supported range is '1000-01-01' to '9999-12-31'.
Time 11 Time

The range is '-838:59:59' to '838:59:59'.
DateTime 12 DateTime The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.
Datetime 12 Obsolete. Datetime The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.
Year 13 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).
Newdate 14 Obsolete Use Datetime or Date type
VarString 15 A variable-length string containing 0 to 65535 characters
Bit 16 Bit-field data type
NewDecimal 246 New Decimal
Enum 247 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
Set 248 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.
TinyBlob 249 A binary column with a maximum length of 255 (2^8 - 1) characters
MediumBlob 250 A binary column with a maximum length of 16777215 (2^24 - 1) bytes.
LongBlob 251 A binary column with a maximum length of 4294967295 or 4G (2^32 - 1) bytes.
Blob 252 A binary column with a maximum length of 65535 (2^16 - 1) bytes.
VarChar 253 A variable-length string containing 0 to 255 bytes.
String 254 A fixed-length string.
Geometry 255 Geometric (GIS) data type.
UByte 501 Unsigned 8-bit value.
UInt16 502 Unsigned 16-bit value.
UInt24 509 Unsigned 24-bit value.
UInt32 503 Unsigned 32-bit value.
UInt64 508 Unsigned 64-bit value.
Binary 600 Fixed length binary string.
VarBinary 601 Variable length binary string.
TinyText 749 A text column with a maximum length of 255 (2^8 - 1) characters.
MediumText 750 A text column with a maximum length of 16777215 (2^24 - 1) characters.
LongText 751 A text column with a maximum length of 4294967295 or 4G (2^32 - 1) characters.
Text 752 A text column with a maximum length of 65535 (2^16 - 1) characters.
Guid 800 A guid column

See Also

previous page start next page