dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlType Enumeration

MySqlType Enumeration
Specifies the data type of a field or MySqlParameter.
Syntax
'Declaration
 
Public Enum MySqlType 
   Inherits System.Enum
   Implements System.IComparableSystem.IConvertibleSystem.IFormattable 
 
Members
MemberDescription
BigIntA MySQL BIGINT data type that contains a 64-bit signed integer. Represented as the System.Int64.
BinaryA MySQL BINARY type is similar to the CHAR type, but stores binary byte strings rather than non-binary character strings. Represented as the System.String.
BitA MySQL BIT data type that contains a bit mask. Represented as the System.Int64.
BlobA MySQL BLOB data type that contains a variable-length stream of binary data. Represented as the array of System.Byte.
CharA CHAR data type that contains a fixed-length character string. Represented as the System.String.
DateA MySQL DATE data type that contains a fixed-length representation of a date value. Represented as the System.DateTime.
DateTimeA MySQL DATETIME data type that contains a fixed-length representation of a date and time value. Represented as the System.DateTime.
DecimalA MySQL DECIMAL data type that contains values ranging from 1.0 x 10(-28) to approximately 7.9 x 10(28) with 28-29 significant digits. Represented as the System.Decimal.
DoubleA MySQL DOUBLE data type. Represented as the System.Double.
FloatA MySQL FLOAT data type. Represented as the System.Float.
GeometryA MySQL Geometric (GIS) data types. Represented as the array of System.Byte.
GuidA MySQL BINARY(16) data type that contains a guid value. Represented as the System.Guid.
IntA MySQL INT data type that contains a 32-bit signed integer. Represented as the System.Int32.
Json 
SmallIntA MySQL SMALLINT data type that contains a 16-bit signed integer. Represented as the System.Int16.
TextA MySQL TEXT data type that contains a variable-length character string. Represented as the System.String.
TimeA MySQL TIME data type that contains a fixed-length representation of a time value. Represented as the System.TimeSpan.
TimeStampA MySQL TIMESTAMP data type that contains date and time, including seconds. Represented as the System.DateTime.
TinyIntA MySQL UNSIGNED TINYINT data type that contains a 8-bit unsigned integer. Represented as the System.Byte.
VarBinaryA MySQL VARBINARY type is similar to the VARCHAR type, but stores binary byte strings rather than non-binary character strings. Represented as the System.String.
VarCharA MySQL VARCHAR data type that contains a variable-length character string. Represented as the System.String.
YearA MySQL YEAR data type that contains a year value. Represented as the System.Int16.
Remarks
This table shows mappings between MySqlType values, MySQL data types, Microsoft .NET Framework types.
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         Devart.Data.MySql.MySqlType

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also