Sybase Data Types

The following tables show the correspondences of Sybase to HCL Enterprise Integrator (HEI) or 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 on the organization of these tables, see the section "Notes® on Connector Data Type Conversion Tables" in Chapter 3.

Execute

The Execute data types are listed as follows.


Sybase		Connector API
BIT		Int
TINYINT		Int
SMALLINT		Int
INT		Int
REAL		Float
FLOAT		Float
DECIMAL	prec-scale<=9, scale<=0	Int
DECIMAL	prec <=15	Float
DECIMAL	other	Numeric
NUMERIC	prec-scale<=9, scale<=0	Int
NUMERIC	prec <=15	Float
NUMERIC	other	Numeric
MONEY		Currency
SMALLMONEY		Currency
DATETIME		Datetime
SMALLDATETIME		Datetime
CHAR		Text (fixed length, bound <= 256)
NCHAR		Text (fixed length, bound <= 256)
VARCHAR		Text (variable length, bound <= 256)
NVARCHAR		Text (variable length, bound <= 256)
TEXT		Text (variable length, unbounded)
BINARY		Binary (fixed length, bound <= 256)
VARBINARY		Binary (variable length, bound <= 256)
IMAGE		Binary (variable length, unbounded)

Fetch

The Fetch data types are listed as follows.


Connector API		Sybase
Int		BIT, TINYINT, SMALLINT, INT, REAL (o), FLOAT (p, o), DECIMAL (p, o), NUMERIC (p, o), MONEY (p, o), SMALLMONEY (p,o)
Float		BIT, TINYINT, SMALLINT, INT, REAL, FLOAT, DECIMAL (p), NUMERIC (p), MONEY (p), SMALLMONEY (p)
Currency		BIT, TINYINT, SMALLINT, INT, REAL (o), FLOAT (o), DECIMAL (p, o), NUMERIC (p, o), MONEY, SMALLMONEY
Numeric		BIT, TINYINT(p, o), SMALLINT (p, o), INT (p, o), REAL (p, o), FLOAT (p, o), DECIMAL (p, o), NUMERIC (p, o), MONEY (p, o), SMALLMONEY (p, o)
Datetime		SMALLDATETIME, DATETIME
Text (o)		CHAR, NCHAR, VARCHAR, NVARCHAR, TEXT, BOUNDARY, SENSITIVITY, BINARY, VARBINARY, IMAGE
Binary (o)	BLOB	CHAR, NCHAR, VARCHAR, NVARCHAR, TEXT, BOUNDARY, BINARY, VARBINARY, IMAGE
	non-BLOB	invalid

Insert/Update

The Insert/Update data types are listed as follows.


Connector API		Sybase
Int		BIT (p), TINYINT (p, o), SMALLINT (p, o), INT, REAL (p), FLOAT, DECIMAL (p), NUMERIC (p), MONEY, SMALLMONEY
Float		BIT (p), TINYINT (p, o), SMALLINT (p, o), INT (p, o), REAL (p, o), FLOAT, DECIMAL (p, o), NUMERIC (p, o), MONEY (p, o), SMALLMONEY (p, o)
Currency		BIT (p), TINYINT (p, o), SMALLINT (p, o), INT (p, o), REAL (p), FLOAT (p, o), DECIMAL (p), NUMERIC (p), MONEY, SMALLMONEY
Numeric		BIT (p), TINYINT (p, o), SMALLINT (p, o), INT (p, o), REAL (p), FLOAT (p, o), DECIMAL (p, o), NUMERIC (p, o), MONEY (p, o), SMALLMONEY (p, o)
Datetime		SMALLDATETIME, DATETIME
Text		CHAR (o), NCHAR (0), VARCHAR (o), NVARCHAR (o), TEXT, BOUNDARY (o), BINARY (o), VARBINARY (o), IMAGE
Binary	any	CHAR (o), NCHAR (0), VARCHAR (o), NVARCHAR (o), LONGCHAR, TEXT, BOUNDARY (o), SENSITIVITY (o), BINARY (o), VARBINARY (o), LONGBINARY, IMAGE
	number list	BIT (p), TINYINT (p, o), SMALLINT (p, o), INT (p, o), REAL (p, o), FLOAT, DECIMAL (p), NUMERIC (p), MONEY (p), SMALLMONEY (p)
	datetime list	SMALLDATETIME, DATETIME

Create

The Create data types are listed as follows.


Connector API		Sybase
Int		INT, NUMERIC (prec), or BIT
Float		FLOAT, NUMERIC (prec), or REAL
Currency		MONEY, SMALLMONEY
Numeric		NUMERIC (prec, scale)
Datetime		SMALLDATETIME, DATETIME
Text		CHAR (fixed, len<=256), NCHAR (fixed, len<=256), VARCHAR (variable, len<=256), NVARCHAR (variable, len<=256), TEXT (len>256)
Binary	BLOB	BINARY(fixed, len<=256), VARBINARY (variable, len<=256), or IMAGE (len>256)
	composite	CHAR (fixed, len<=256), NCHAR (fixed, len<=256), VARCHAR (variable, len<=256), NVARCHAR (variable, len<=256), TEXT (len>256)
	number list	FLOAT
	datetime list	SMALLDATETIME, DATETIME
	text list	CHAR (fixed, len<=256), NCHAR (fixed, len<=256), VARCHAR (variable, len<=256), NVARCHAR (variable, len<=256), TEXT (len>256)