Enumerates the UltraLite.NET database data types.
Visual Basic Public Enum ULDbType
C# public enum ULDbType
The table below lists which .NET types are compatible with each ULDbType. In the case of integral types, table columns can always be set using smaller integer types, but can also be set using larger types as long as the actual value is within the range of the type.
ULDbType |
Compatible .NET type |
C# built-in type |
Visual Basic built-in type |
---|---|---|---|
Binary, VarBinary | System.Byte[], or System.Guid if size is 16 | byte[] | Byte() |
Bit | System.Boolean | bool | Boolean |
Char, VarChar | System.String | String | String |
Date | System.DateTime |
DateTime No built-in type. |
Date |
Double | System.Double | double | Double |
LongBinary | System.Byte[] | byte[] | Byte() |
LongVarchar | System.String | String | String |
Decimal, Numeric | System.String | decimal | Decimal |
Float, Real | System.Single | float | Single |
BigInt | System.Int64 | long | Long |
Integer | System.Int32 | int | Integer |
SmallInt | System.Int16 | short | Short |
Time | System.TimeSpan |
TimeSpan No built-in type. |
TimeSpan No built-in type. |
DateTime, TimeStamp | System.DateTime |
DateTime No built-in type. |
Date |
TinyInt | System.Byte | byte | Byte |
UnsignedBigInt | System.UInt64 | ulong |
UInt64 No built-in type. |
UnsignedInt | System.UInt32 | uint |
UInt32 No built-in type. |
UnsignedSmallInt | System.UInt16 | ushort |
UInt16 No built-in type. |
UniqueIdentifier | System.Guid |
Guid No built-in type. |
Guid No built-in type. |
Binary columns of length 16 are fully compatible with the UniqueIdentifier type.
Member name | Description | Value |
---|---|---|
BigInt |
Signed 64-bit integer. |
5 |
Binary |
Binary data, with a specified maximum length. The enumeration values Binary and VarBinary are aliases of each other. |
15 |
Bit |
1-bit flag. |
8 |
Char |
Character data, with a specified length. In UltraLite.NET, this type always supports Unicode characters. The types Char and VarChar are fully compatible. |
0 |
Date |
Date information. |
10 |
DateTime |
Timestamp information (date, time). The enumeration values DateTime and TimeStamp are aliases of each other. |
9 |
Decimal |
Exact numerical data, with a specified precision and scale. The enumeration values Decimal and Numeric are aliases of each other. |
14 |
Double |
Double precision floating-point number (8 bytes). |
12 |
Float |
Single precision floating-point number (4 bytes). The enumeration values Float and Real are aliases of each other. |
13 |
Integer |
Unsigned 32-bit integer. |
1 |
LongBinary |
Binary data, with variable length. |
18 |
LongVarchar |
Character data, with variable length. In UltraLite.NET, this type always supports Unicode characters. |
17 |
Numeric |
Exact numerical data, with a specified precision and scale. The enumeration values Decimal and Numeric are aliases of each other. |
14 |
Real |
Single precision floating-point number (4 bytes). The enumeration values Float and Real are aliases of each other. |
13 |
SmallInt |
Signed 16-bit integer. |
3 |
Time |
Time information. |
11 |
TimeStamp |
Timestamp information (date, time). The enumeration values DateTime and TimeStamp are aliases of each other. |
9 |
TinyInt |
Unsigned 8-bit integer. |
7 |
UniqueIdentifier |
Universally Unique Identifier (UUID/GUID). |
19 |
UnsignedBigInt |
Unsigned 64-bit integer. |
6 |
UnsignedInt |
Unsigned 32-bit integer. |
2 |
UnsignedSmallInt |
Unsigned 16-bit integer. |
4 |
VarBinary |
Binary data, with a specified maximum length. The enumeration values Binary and VarBinary are aliases of each other. |
15 |
VarChar |
Character data, with a specified maximum length. In UltraLite.NET, this type always supports Unicode characters. The types Char and VarChar are fully compatible. |
16 |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |