Data types

The following data types are referenced throughout this document and used in the Act! SDK.  Act! data type descriptions and SQL data type descriptions are included in this documentation.

Act! data type SQL data type .NET data type

Annual Event

DATETIME

System.DateTime

Char

CHAR

System.String

Character

NVARCHAR

System.String

Currency

MONEY

System.Decimal

Date

DATETIME

System.DateTime

Datetime

DATETIME

System.DateTime

Decimal

DECIMAL

System.Decimal

Email

NVARCHAR

System.String

Initial Caps

NVARCHAR

System.String

KeyID

UNIQUEIDENTIFIER

System.Guid

Lowercase

NVARCHAR

System.string

Memo

NTEXT

System.String

Monthly Event

DATETIME

System.DateTime

NChar

NCHAR

System.String

Number

INT

System.Int32

Phone

NVARCHAR

System.String

Picture

IMAGE

System.Drawing.Image

RecordType

UNIQUEIDENTIFIER

System.Guide

Smalldatetime

SMALLDATETIME

System.DateTime

Smallint

SMALLINT

System.Int16

Time

DATETIME

System.DateTime

Tinyint

TINYINT

System.Byte

Uppercase

NVARCHAR

System.String

URL Address

NVARCHAR

System.String

Varbinary

VARBINARY

System.Byte[]

Yes/No

BIT

System.Boolean