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)