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) |