Data Types Reference

Data types for columns and parameters in the Databases configuration are displayed using names derived from ActiveX Data Objects (ADO). The following table shows the mapping between the display names used in a configuration and the corresponding SQL Server and .NET types. The types in Bold are the recommended types to use when mapping database types in GENESIS.

For more information about ADO types and mapping to .NET types, refer to OLE DB Data Type Mappings (external).

Display Name

SQL Server Type

.NET Type

Notes

Array

N/A

Object

Not used.

Bigint

bigint

Int64

Signed 64-bit integer.

Bigint (unsigned)

bigint

UInt64

Unsigned 64-bit integer.

Binary

binary

Byte[]

Binary data.

Bool

bit

Boolean

A true/false value.

BSTR

N/A

String

Variable-length string.

Chapter

N/A

Object

Not used.

Char

char(n)

String

Fixed-length string. See char and varchar (external).

Currency

money

Decimal

16 bytes floating-point. See Floating-point numeric types (external).

Date

date

DateTime

Date only.

DateTime

datetime

Date Time

Date and time.

DateTimeOffset

datetimeoffset

DateTimeOffset

Date, time and a UTC offset.

DBTimestamp

datetime

DateTime

Date and time.

Decimal

decimal

Decimal

16 bytes floating-point. See Floating-point numeric types (external).

Double

float

Double

8 bytes floating-point. See Floating-point numeric types (external).

Empty

N/A

Object

Not used.

Error

N/A

Object

Not used.

GUID

uniqueidentifier

Guid

A 16 bytes identifier. See GUID (external).

IDispatch

N/A

Object

Not used.

Int

int

Int32

Signed 32-bit integer.

Int (unsigned)

int

UInt32

Unsigned 32-bit integer.

IUnknown

N/A

Object

Not used.

LongVarChar

varchar(MAX)

String

Variable-length string. See char and varchar (external).

LongVarWChar

nvarchar(MAX)

String

Variable-length string. See nchar and nvarchar (external).

Numeric

decimal

Decimal

16 bytes floating-point. See Floating-point numeric types (external).

PropVariant

N/A

Object

Not used.

REF Cursor (Oracle)

REF Cursor

Object

Used for Oracle REF Cursors.

Single

real

Single

4 bytes floating-point. See Floating-point numeric types (external).

Smallint

smallint

Int16

Signed 16-bit integer.

Smallint (unsigned)

smallint

UInt16

Unsigned 16-bit integer.

SqlTime

N/A

TimeSpan

Time only.

Time

time(7)

TimeSpan

Time only.

Timestamp

timestamp

Byte[]

A binary timestamp.

Tinyint

N/A

SByte

Signed 8-bit integer.

Tinyint (unsigned)

tinyint

Byte

Unsigned 8-bit integer.

User Defined

N/A

Object

Not used.

VarChar

varchar(n)

String

Variable-length string. See char and varchar (external).

Variant

sql_variant

Object

Not used.

VarNumeric

decimal

Decimal

16 bytes floating-point. See Floating-point numeric types (external).

VarWChar

nvarchar(n)

String

Variable-length string. See nchar and nvarchar (external).

WChar

nchar(n)

String

Fixed-length string. See nchar and nvarchar (external).

XML

xml

Object

Not used.