Data Types

When working with functions and expressions, field data types are indicated by a single-letter designation that appears in the bottom right corner of each field icon. The following is a list of the letter designations used in Data Guru to represent each data type:

• B - boolean
• D - datetime
• C - decimal
• I - integer
• R - real
• T - time
• L - literal

The following example shows how these letter designations are used for each data type in the database:

Logical functions that return a Boolean data type appear only in action filters and the “When” clause of the Conditional Update transform. These include:

• Contains
• DoesNotContain
• DoesNotEndWith
• DoesNotStartWith
• EndsWith
• InList
• InValueRange
• IsDefaultAll
• IsDefaultAny
• IsEmptyAll
• IsEmptyAny
• IsNotDefaultAll
• IsNotDefaultAny
• IsNotEmptyAll
• IsNotEmptyAny
• IsNotNullAll
• IsNotNullAny
• IsNotNullOrDefaultAll
• IsNotNullOrDefaultAny
• IsNotNullOrEmptyAll
• IsNotNullOrEmptyAny
• IsNotNullOrZeroAll
• IsNotNullOrZeroAny
• IsNotZeroAll
• IsNotZeroAny
• IsNullAll
• IsNullAny
• IsNullOrDefaultAll
• IsNullOrDefaultAny
• IsNullOrEmptyAll
• IsNullOrEmptyAny
• IsNullOrZeroAll
• IsNullOrZeroAny
• IsZeroAll
• IsZeroAny
• NotInList
• StartsWith

All other functions can appear in action filters and elsewhere in the action.

Data type descriptions

Data Guru DataType	Data type	Description	Max size	Storage
StringA	varchar(max)	Variable width character string	1,073,741,824 characters	2 bytes + number of chars
StringU	nvarchar(max)	Variable width Unicode string	536,870,912 characters
Blob	varbinary(max)	Variable width binary string	2GB
DateTime	datetime	From January 1, 1753 to December 31, 9999 with an accuracy of 3.33 milliseconds	8 bytes
Date	date	Store a date only from January 1, 0001 to December 31, 9999	3 bytes
Time	time	Store a time only to an accuracy of 100 nanoseconds	3-5 bytes
Boolean	BIT	Integer that can be 0, 1, or NULL

Data type matches for SQL Server database

The following table shows how the data types in Data Guru are matched to those from a SQL Server database:

Data Guru Data Type	SQL Server Data Type	Description	From	TO
UInt8	TINYINT	A very small integer.	0	255
Int16	SMALLINT	A small integer.	-32,768	32,767
Int32	INT	A medium integer.	-2,147,483,648	2,147,483,647
Int64	BIGINT	A large integer.	-9,223,372,036,854,775,808	9,223,372,036,854,775,807
Single	REAL	Floating precision number data	-3.40E+38	3.40E+38
Double	FLOAT	Floating precision number data	-17.79E+308	1.79E+308
Currency	MONEY	Monetary data	-922,337,203,685,477.5808	922,337,203,685,477.5807
Decimal(p,s)	Decimal (p,s)	Fixed precision and scale numbers. The p parameter indicates the maximum total number of digits that can be stored (both to the left and to the right of the decimal point). p must be a value from 1 to 38. Default is 18.	The s parameter indicates the maximum number of digits stored to the right of the decimal point. s must be a value from 0 to p. Default value is 0 -1E+38	1E+38