Mimer Data Provider v9.2

MimerDbType Enumeration

MimerDbType enumeration. Used for the data type of a field, a property, or a Parameter object of the Mimer Data Provider.

[Visual Basic]
Public Enum MimerDbType
[C#]
public enum MimerDbType

Remarks

The naming is based on the SQL Standard data types.

The following non-standard data types are included for their usefulness: VarBinary, Guid, and Object.

If you want to use unsigned data types this can be done by setting the DbType property to UInt32 or other unsigned data type supported by the DbType enumeration.

The term Tinyint is treated differently by different providers (signed or unsigned). Any use of Tinyint can use the corresponding Byte and SByte respectively.

Members

Member NameDescription
BigInt A signed 64-bit integer. Values can range from -9223372036854775808 to 9223372036854775807.
Blob Binary 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.
Boolean Type representing boolean values (true or false).
Char A fixed length Ascii string.
Clob Character large object. A variable-length stream of ascii data ranging from 0 to 231 - 1 (or 2,147,483,647) bytes.
Date Date data. This is typically represented by a DateTime structure.
Decimal A decimal data type. This is typically represented by a Decimal structure.
Double A 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.
Guid A globally unique identifier (GUID).
Int A signed 32-bit integer. Values can range from -2147483648 to 2147483647.
NChar A fixed length UTF16 Unicode character string.
NClob National character large object. A variable-length stream of Unicode data with a maximum length of 231 - 1 (or 1,073,741,823) characters.
NVarChar A variable length UTF16 Unicode character string. This is the standard String type in .NET.
Object A general type. Can represent any reference or value type not explicitly represented by another MimerDbType value.
Real Single precision float. Value can range from 1.5 x 10-45 to 3.4 x 1038 with a precision of 7 digits.
SmallInt A signed 16-bit integer. Values can range from -32768 to 32767.
Time Used to hold a time value. This is typically represented by a DateTime structure.
Timestamp Used to hold a time value for a particular date. This is typically represented by a DateTime structure.
VarBinary Variable length binary data. Typically, a maximum of 8000 bytes allowed.
VarChar A variable length Ascii string. Typically, a maximum of 8000 characters are allowed.

Requirements

Namespace: Mimer.Data.Client

Assembly: Mimer.Data.Client (in Mimer.Data.Client.dll)

See Also

Mimer.Data.Client Namespace