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

In This Topic
    MySqlType Enumeration
    In This Topic
    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