Collection Contents Previous Next PDF

UltraLite.NET User's Guide

iAnywhere.Data.UltraLite namespace

ULDbType enumeration

Enumerates the UltraLite.NET database data types.

Prototypes 

' 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, VarBinary System.[external link] Byte[], or System.[external link] Guid if size is 16 byte[] Byte()
Bit System.[external link] Boolean bool Boolean
Char, VarChar System.[external link] String String String
Date System.[external link] DateTime DateTime No built-in type. Date
Double System.[external link] Double double Double
LongBinary System.[external link] Byte[] byte[] Byte()
LongVarchar System.[external link] String String String
Decimal, Numeric System.[external link] String decimal Decimal
Float, Real System.[external link] Single float Single
BigInt System.[external link] Int64 long Long
Integer System.[external link] Int32 int Integer
SmallInt System.[external link] Int16 short Short
Time System.[external link] TimeSpan TimeSpan No built-in type. TimeSpan No built-in type.
DateTime, TimeStamp System.[external link] DateTime DateTime No built-in type. Date
TinyInt System.[external link] Byte byte Byte
UnsignedBigInt System.[external link] UInt64 ulong UInt64 No built-in type.
UnsignedInt System.[external link] UInt32 uint UInt32 No built-in type.
UnsignedSmallInt System.[external link] UInt16 ushort UInt16 No built-in type.
UniqueIdentifier System.[external link] Guid Guid No built-in type. Guid No built-in type.

Binary columns of length 16 are fully compatible with the UniqueIdentifier type.

Members 
Member Description
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 

Collection Contents Previous Next PDF

SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.