Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - .NET Programming » UltraLite .NET 1.0 API Reference

ULDateOrder enumeration Next Page

ULDbType enumeration


Enumerates the UltraLite.NET database data types.

Syntax

Visual Basic

Public Enum ULDbType

C#

public enum ULDbType

Remarks

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, VarBinarySystem.Byte[], or System.Guid if size is 16byte[]Byte()
BitSystem.BooleanboolBoolean
Char, VarCharSystem.StringStringString
DateSystem.DateTime

DateTime

No built-in type.

Date
DoubleSystem.DoubledoubleDouble
LongBinarySystem.Byte[]byte[]Byte()
LongVarcharSystem.StringStringString
Decimal, NumericSystem.StringdecimalDecimal
Float, RealSystem.SinglefloatSingle
BigIntSystem.Int64longLong
IntegerSystem.Int32intInteger
SmallIntSystem.Int16shortShort
TimeSystem.TimeSpan

TimeSpan

No built-in type.

TimeSpan

No built-in type.

DateTime, TimeStampSystem.DateTimeDateTime No built-in type.Date
TinyIntSystem.BytebyteByte
UnsignedBigIntSystem.UInt64ulong

UInt64

No built-in type.

UnsignedIntSystem.UInt32uint

UInt32

No built-in type.

UnsignedSmallIntSystem.UInt16ushort

UInt16

No built-in type.

UniqueIdentifierSystem.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
Member nameDescription

BigInt

Signed 64-bit integer.

Binary

Binary data, with a specified maximum length. The enumeration values Binary and VarBinary are aliases of each other.

Bit

1-bit flag.

Char

Character data, with a specified length. In UltraLite.NET, this type always supports Unicode characters. The types Char and VarChar are fully compatible.

Date

Date information.

DateTime

Timestamp information (date, time). The enumeration values DateTime and TimeStamp are aliases of each other.

Decimal

Exact numerical data, with a specified precision and scale. The enumeration values Decimal and Numeric are aliases of each other.

Double

Double precision floating-point number (8 bytes).

Float

Single precision floating-point number (4 bytes). The enumeration values Float and Real are aliases of each other.

Integer

Unsigned 32-bit integer.

LongBinary

Binary data, with variable length.

LongVarchar

Character data, with variable length. In UltraLite.NET, this type always supports Unicode characters.

Numeric

Exact numerical data, with a specified precision and scale. The enumeration values Decimal and Numeric are aliases of each other.

Real

Single precision floating-point number (4 bytes). The enumeration values Float and Real are aliases of each other.

SmallInt

Signed 16-bit integer.

Time

Time information.

TimeStamp

Timestamp information (date, time). The enumeration values DateTime and TimeStamp are aliases of each other.

TinyInt

Unsigned 8-bit integer.

UniqueIdentifier

Universally Unique Identifier (UUID/GUID).

UnsignedBigInt

Unsigned 64-bit integer.

UnsignedInt

Unsigned 32-bit integer.

UnsignedSmallInt

Unsigned 16-bit integer.

VarBinary

Binary data, with a specified maximum length. The enumeration values Binary and VarBinary are aliases of each other.

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.

See also