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 |
||
Character |
NVARCHAR |
System.String |
Currency |
MONEY |
|
Date |
DATETIME |
System.DateTime |
Datetime |
DATETIME |
System.DateTime |
Decimal |
DECIMAL |
System.Decimal |
|
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 |
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 |
|
Uppercase |
NVARCHAR |
System.String |
URL Address |
NVARCHAR |
System.String |
Varbinary |
VARBINARY |
System.Byte[] |
Yes/No |
BIT |