Mimer SQL Data Provider help
MimerDbType Enumeration




Mimer.Data.Client Namespace : MimerDbType Enumeration
The MimerDbType enumeration is used to specify the SQL data type of a field, a property, or a Parameter object in the Mimer Data Provider.
Syntax
'Declaration
 
Public Enum MimerDbType 
   Inherits System.Enum
public enum MimerDbType : System.Enum 
public enum MimerDbType = class(System.Enum)
public enum MimerDbType extends System.Enum
__value public enum MimerDbType : public System.Enum 
Members
MemberDescription
BigIntA signed 64-bit integer. Values can range from -9223372036854775808 to 9223372036854775807.
BinaryFixed length binary data.
BlobBinary large object. A variable-length stream of binary data ranging from 0 to 231 - 1 (or 2,147,483,647) bytes.

This type is used, for example, to store images.

BooleanType representing boolean values (true or false).
CharA fixed length Ascii string.
ClobCharacter large object. A variable-length stream of ascii data ranging from 0 to 231 - 1 (or 2,147,483,647) bytes.
DateDate data. This is typically represented by a System.DateTime structure.
DecimalA decimal data type. This is typically represented by a System.Decimal structure.
DoubleA double precision float. Values can range from approximately 5.0 x 10-324 to 1.7 x 10308 with a precision of 15-16 digits.
GuidA globally unique identifier (GUID).
IntA signed 32-bit integer. Values can range from -2147483648 to 2147483647.
IntervalDayA time interval of days.
IntervalDayToHourA time interval of days and hours.
IntervalDayToMinuteA time interval of days, hours, and minutes.
IntervalDayToSecondA time interval of days, hours, minutes, seconds, and optional fractions of seconds.
IntervalHourA time interval of hours.
IntervalHourToMinuteA time interval of hours and minutes.
IntervalHourToSecondA time interval of hours, minutes, seconds, and optional fractions of seconds.
IntervalMinuteA time interval of minutes.
IntervalMinuteToSecondA time interval of minutes, seconds, and optional fractions of seconds.
IntervalMonthA time interval of months.
IntervalSecondA time interval of seconds and optional fractions of seconds.
IntervalYearA time interval of years.
IntervalYearToMonthA time interval of years and months.
MimerFloatMimer SQL specific floating point number with between 1 and 45 digits precision.
MimerIntMimer SQL specific integer type with between 1 and 45 digits precision.
NCharA fixed length UTF16 Unicode character string.
NClobNational character large object. A variable-length stream of Unicode data with a maximum length of 231 - 1 (or 1,073,741,823) characters.
NumericA numeric data type with precision and scale. This is typically represented by a System.Decimal structure.
NVarCharA variable length UTF16 Unicode character string. This is the standard System.String type in .NET.
ObjectA general type. Can represent any reference or value type not explicitly represented by another MimerDbType value.
RealSingle precision float. Value can range from 1.5 x 10-45 to 3.4 x 1038 with a precision of 7 digits.
SmallIntA signed 16-bit integer. Values can range from -32768 to 32767.
TimeUsed to hold a time value. This is typically represented by a System.DateTime structure.
TimestampUsed to hold a time value for a particular date. This is typically represented by a System.DateTime structure.
UserDefinedTypeUser defined type. This type consists of one or more subtypes.
VarBinaryVariable length binary data. Typically, a maximum of 8000 bytes allowed.
VarCharA variable length Ascii string. Typically, a maximum of 8000 characters are allowed.
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         Mimer.Data.Client.MimerDbType

Requirements

.NET Framework
Version 2.0 or later

See Also

Reference

Mimer.Data.Client Namespace