Gemstone Data Library
Ole
Specifies the data type of a field, a property.
Definition
Namespace: Gemstone.Data
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.128 -- Release Build+cb657b646daac3e9cc5384ff42ed4530df50eab1
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.128 -- Release Build+cb657b646daac3e9cc5384ff42ed4530df50eab1
C#
public enum OleDbTypeVB
Public Enumeration OleDbTypeC++
public enum class OleDbTypeJavaScript
Gemstone.Data.OleDbType = function();
Gemstone.Data.OleDbType.createEnum('Gemstone.Data.OleDbType', false);Remarks
Copied from System.Data.OleDb.OleDbParameter in the .NET Framework.
Members
| Empty | 0 | No value (DBTYPE_EMPTY). |
| SmallInt | 2 | A 16-bit signed integer (DBTYPE_I2). This maps to Int16. |
| Integer | 3 | A 32-bit signed integer (DBTYPE_I4). This maps to Int32. |
| Single | 4 | A floating-point number within the range of -3.40E +38 through 3.40E +38 (DBTYPE_R4). This maps to Single. |
| Double | 5 | A floating-point number within the range of -1.79E +308 through 1.79E +308 (DBTYPE_R8). This maps to Double. |
| Currency | 6 | A currency value ranging from -2 63 (or -922,337,203,685,477.5808) to 2 63 -1 (or +922,337,203,685,477.5807) with an accuracy to a ten-thousandth of a currency unit (DBTYPE_CY). This maps to Decimal. |
| Date | 7 | Date data, stored as a double (DBTYPE_DATE). The whole portion is the number of days since December 30, 1899, and the fractional portion is a fraction of a day. This maps to DateTime. |
| BSTR | 8 | A null-terminated character string of Unicode characters (DBTYPE_BSTR). This maps to String. |
| IDispatch | 9 | A pointer to an IDispatch interface (DBTYPE_IDISPATCH). This maps to Object. |
| Error | 10 | A 32-bit error code (DBTYPE_ERROR). This maps to Exception. |
| Boolean | 11 | A Boolean value (DBTYPE_BOOL). This maps to Boolean. |
| Variant | 12 | A special data type that can contain numeric, string, binary, or date data, and also the special values Empty and Null (DBTYPE_VARIANT). This type is assumed if no other is specified. This maps to Object. |
| IUnknown | 13 | A pointer to an IUnknown interface (DBTYPE_UNKNOWN). This maps to Object. |
| Decimal | 14 | A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1 (DBTYPE_DECIMAL). This maps to Decimal. |
| TinyInt | 16 | A 8-bit signed integer (DBTYPE_I1). This maps to SByte. |
| UnsignedTinyInt | 17 | A 8-bit unsigned integer (DBTYPE_UI1). This maps to Byte. |
| UnsignedSmallInt | 18 | A 16-bit unsigned integer (DBTYPE_UI2). This maps to UInt16. |
| UnsignedInt | 19 | A 32-bit unsigned integer (DBTYPE_UI4). This maps to UInt32. |
| BigInt | 20 | A 64-bit signed integer (DBTYPE_I8). This maps to Int64. |
| UnsignedBigInt | 21 | A 64-bit unsigned integer (DBTYPE_UI8). This maps to UInt64. |
| Filetime | 64 | A 64-bit unsigned integer representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME). This maps to DateTime. |
| Guid | 72 | A globally unique identifier (or GUID) (DBTYPE_GUID). This maps to Guid. |
| Binary | 128 | A stream of binary data (DBTYPE_BYTES). This maps to an Array of type Byte. |
| Char | 129 | A character string (DBTYPE_STR). This maps to String. |
| WChar | 130 | A null-terminated stream of Unicode characters (DBTYPE_WSTR). This maps to String. |
| Numeric | 131 | An exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC). This maps to Decimal. |
| DBDate | 133 | Date data in the format yyyymmdd (DBTYPE_DBDATE). This maps to DateTime. |
| DBTime | 134 | Time data in the format hhmmss (DBTYPE_DBTIME). This maps to TimeSpan. |
| DBTimeStamp | 135 | Data and time data in the format yyyymmddhhmmss (DBTYPE_DBTIMESTAMP). This maps to DateTime. |
| PropVariant | 138 | An automation PROPVARIANT (DBTYPE_PROP_VARIANT). This maps to Object. |
| VarNumeric | 139 | A variable-length numeric value (OleDbParameter only). This maps to Decimal. |
| VarChar | 200 | A variable-length stream of non-Unicode characters (OleDbParameter only). This maps to String. |
| LongVarChar | 201 | A long string value (OleDbParameter only). This maps to String. |
| VarWChar | 202 | A variable-length, null-terminated stream of Unicode characters (OleDbParameter only). This maps to String. |
| LongVarWChar | 203 | A long null-terminated Unicode string value (OleDbParameter only). This maps to String. |
| VarBinary | 204 | A variable-length stream of binary data (OleDbParameter only). This maps to an Array of type Byte. |
| LongVarBinary | 205 | A long binary value (OleDbParameter only). This maps to an Array of type Byte. |