SADbType enumeration

Enumerates the SQL Anywhere .NET database data types.

Syntax 
Visual Basic

Public Enum SADbType 
C#

public enum SADbType
Remarks

The table below lists which .NET types are compatible with each SADbType. 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.

SADbType

Compatible .NET type

C# built-in type

Visual Basic built-in type
BigInt System.[external link] Int64 long Long
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
DateTime, TimeStamp System.[external link] DateTime DateTime (no built-in type) Date
Decimal, Numeric System.[external link] String decimal Decimal
Double System.[external link] Double double Double
Float, Real System.[external link] Single float Single
Image System.[external link] Byte[] byte[] Byte()
Integer System.[external link] Int32 int Integer
LongBinary System.[external link] Byte[] byte[] Byte()
LongNVarChar System.[external link] String String String
LongVarChar System.[external link] String String String
Money System.[external link] String decimal Decimal
NChar System.[external link] String String String
NText System.[external link] String String String
Numeric System.[external link] String decimal Decimal
NVarChar System.[external link] String String String
SmallDateTime System.[external link] DateTime DateTime (no built-in type) Date
SmallInt System.[external link] Int16 short Short
SmallMoney System.[external link] String decimal Decimal
SysName System.[external link] String String String
Text System.[external link] String String String
Time System.[external link] TimeSpan TimeSpan (no built-in type) TimeSpan (no built-in type)
TimeStamp System.[external link] DateTime DateTime (no built-in type) Date
TinyInt System.[external link] Byte byte Byte
UniqueIdentifier System.[external link] Guid Guid (no built-in type) Guid (no built-in type)
UniqueIdentifierStr System.[external link] String String String
UnsignedBigInt System.[external link] UInt64 ulong UInt64 (no built-in type)
UnsignedInt System.[external link] UInt32 uint UInt64 (no built-in type)
UnsignedSmallInt System.[external link] UInt16 ushort UInt64 (no built-in type)
Xml System.[external link] System.Xml String String

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

Members
Member name Description Value

BigInt

Signed 64-bit integer.

 1

Binary

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

 2

Bit

1-bit flag.

 3

Char

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

4

Date

Date information.

 5

DateTime

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

 6

Decimal

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

7

Double

Double precision floating-point number (8 bytes).

 8

Float

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

 9

Image

Stores binary data of arbitrary length.

 10

Integer

Unsigned 32-bit integer.

 11

LongBinary

Binary data, with variable length.

 12

LongNVarchar

Character data in the NCHAR character set, with variable length. This type always supports Unicode characters.

 13

LongVarbit

Bit arrays, with variable length.

 14

LongVarchar

Character data, with variable length. This type always supports Unicode characters.

 15

Money

Monetary data.

 16

NChar

Stores Unicode character data, up to 8191 characters.

 17

NText

Stores Unicode character data of arbitrary length.

 18

Numeric

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

19

NVarChar

Stores Unicode character data, up to 8191 characters.

 20

Real

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

 21

SmallDateTime

A domain, implemented as TIMESTAMP.

 22

SmallInt

Signed 16-bit integer.

 23

SmallMoney

Stores monetary data that is less than one million currency units.

 24

SysName

Stores character data of arbitrary length.

 25

Text

Stores character data of arbitrary length.

 26

Time

Time information.

 27

TimeStamp

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

 28

TinyInt

Unsigned 8-bit integer.

 29

UniqueIdentifier

Universally Unique Identifier (UUID/GUID).

 30

UniqueIdentifierStr

A domain, implemented as CHAR( 36 ). UniqueIdentifierStr is used for remote data access when mapping Microsoft SQL Server uniqueidentifier columns.

31

UnsignedBigInt

Unsigned 64-bit integer.

 32

UnsignedInt

Unsigned 32-bit integer.

 33

UnsignedSmallInt

Unsigned 16-bit integer.

 34

VarBinary

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

35

VarBit

Bit arrays that are from 1 to 32767 bits in length.

 36

VarChar

Character data, with a specified maximum length. This type always supports Unicode characters. The types Char and VarChar are fully compatible.

37

Xml

XML data. This type stores character data of arbitrary length, and is used to store XML documents.

 38
See also
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1