Microsoft™ SQL Server Data Types

The following tables show the correspondences of Microsoft™ SQL server to IBM® Lotus Enterprise Integrator® (LEI) and Domino® Enterprise Connection Services (DECS) data types for various types of activities.

(p) -- Indicates that if Allow Precision Loss is not enabled, then an error will be generated on the type match. Allowing precision loss is the default.
(o) -- Indicates that overflow checking will be performed when data is being transferred. If an overflow occurs and Truncate Data When Necessary is enabled, then the data is truncated; if not, an error is generated.

For more information about these tables, see chapter 3.

Execute

The Execute data types are listed as follows.


Microsoft™ SQL Server	Lotus® Connector API
BIT	Int
TINYINT	Int
SMALLINT	Int
INT	Int
REAL	Float
FLOAT	Float
DECIMAL	Numeric
NUMERIC	Numeric
UNIQUEIDENTIFIER	Text (fixed length, bound = 39)
SMALLMONEY	Currency
MONEY	Currency
SMALLDATETIME	Datetime
DATETIME	Datetime
CHAR	Text (fixed length, bound <= 8000)
VARCHAR	Text (variable length, bound <= 8000)
TEXT	Text (variable length, unbounded)
NCHAR	Text (fixed length, bound <= 8000)
NVARCHAR	Text (variable length, bound <= 8000)
NTEXT	Text (variable length, unbounded)
BINARY	Binary (fixed length, bound <= 8000)
VARBINARY	Binary (variable length, bound <= 8000)
IMAGE	Binary (variable length, unbounded)
TIMESTAMP	Binary

Fetch

The Fetch data types are listed as follows.


Microsoft™ SQL Server	Lotus® Connector API
BIT, TINYINT, SMALLINT, INT	Int
TINYINT, SMALLINT, INT, REAL, FLOAT, DECIMAL (p, o), NUMERIC (p, o), SMALLMONEY, MONEY (p)	Float
TINYINT, SMALLINT, INT, REAL (o), FLOAT (o), DECIMAL (p, o), NUMERIC (p, o), SMALLMONEY, MONEY	Currency
TINYINT(p, o), SMALLINT (p, o), INT (p, o), REAL (p, o), FLOAT (p, o), DECIMAL (p, o), NUMERIC (p, o), SMALLMONEY(p, o), MONEY (p, o)	Numeric
SMALLDATETIME, DATETIME (p)	Datetime
CHAR, VARCHAR, TEXT, NCHAR, NVARCHAR, NTEXT, BINARY, VARBINARY, IMAGE, TIMESTAMP UNIQUEIDENTIFIER	Text (o)
CHAR, VARCHAR, TEXT, BINARY, VARBINARY, IMAGE, TIMESTAMP	Binary (o)	BLOB
SMALLDATETIME, DATETIME (p)		Datetime list
TINYINT, SMALLINT, INT, REAL, FLOAT, DECIMAL (p, o), NUMERIC (p, o), SMALLMONEY, MONEY (p)		Number list
CHAR, VARCHAR, TEXT, NCHAR, NVARCHAR, NTEXT, BINARY, VARBINARY, IMAGE, TIMESTAMP UNIQUEIDENTIFIER		Text list

Insert/Update

The Insert/Update data types are listed as follows.


Lotus® Connector API	Microsoft™ SQL Server
Int		BIT, TINYINT (p, o), SMALLINT (p, o), INT, REAL (p), FLOAT, DECIMAL (p), NUMERIC (p), SMALLMONEY, MONEY, CHAR (o), VARCHAR (o), TEXT, NCHAR (o), NVARCHAR (o), NTEXT
Float		TINYINT (p, o), SMALLINT (p, o), INT (p, o), REAL (p, o), FLOAT, DECIMAL (p, o), NUMERIC (p, o), SMALLMONEY (p, o), MONEY (p, o), CHAR (o), VARCHAR (o), TEXT, NCHAR (o), NVARCHAR (o), NTEXT
Currency		INT (p, o), REAL (p, o), FLOAT (p, o), DECIMAL (p), NUMERIC (p), SMALLMONEY (p, o), MONEY, CHAR (o), VARCHAR (o), TEXT, NCHAR (o), NVARCHAR (o), NTEXT
Numeric		INT (p, o), REAL (p, o), FLOAT (p, o), DECIMAL (p, o), NUMERIC (p, o), CHAR (o), VARCHAR (o), NCHAR (o), NVARCHAR (o)
Datetime		SMALLDATETIME (p), DATETIME
Text		CHAR (o), VARCHAR (o), TEXT, NCHAR (o), NVARCHAR (o), NTEXT, BINARY (o), VARBINARY (o), IMAGE
Binary:	BLOB	CHAR (o), VARCHAR (o), TEXT, BINARY (o), VARBINARY (o), IMAGE
	number list	TINYINT (p, o), SMALLINT (p, o), INT (p, o), REAL (p, o), FLOAT, DECIMAL (p, o), NUMERIC (p, o), SMALLMONEY (p, o), MONEY (p, o), CHAR (o), VARCHAR (o), TEXT, NCHAR (o), NVARCHAR (o), NTEXT
	datetime list	SMALLDATETIME (p), DATETIME

Create

The Create data types are listed as follows.


Lotus® Connector API	Microsoft™ SQL Server
Int		INT, TINYINT, SMALLINT, or BIT
Float		FLOAT, or REAL
Currency		MONEY, SMALLMONEY
Numeric		NUMERIC (prec, scale)
Datetime		DATETIME or DATETIME4
Text		CHAR (fixed, len<=8000), VARCHAR (variable, len<=8000), or TEXT (len>8000)
Binary:	BLOB	BINARY(fixed, len<=8000), VARBINARY (variable, len<=8000), or IMAGE (len>8000)
	composite	CHAR (fixed, len<=8000), VARCHAR (variable, len<=8000), or TEXT (len>8000)
	number list	FLOAT
	datetime list	DATETIME
	text list	CHAR (fixed, len<=8000), VARCHAR (variable, len<=8000), or TEXT (len>8000)