Sybase data type mapping and issues

Sybase table and column names must not exceed 28 characters.

When using Sybase, an expression in a WHERE clause can contain the power function and a decimal value with up to five digits in the fractional part of the value. The following WHERE clause shows this type of expression:

WHERE power(ACNULLDATATYPES.ACDECIMAL, 2) > 1.12345

Do not use expressions in the WHERE clause that have a power function and a decimal value with six or more digits in the fractional part of the value. For example, the following WHERE clause causes an error:

WHERE power(ACNULLDATATYPES.ACDECIMAL, 2) > 1.123456

Table 8-5 shows how Sybase data types map to Actuate SQL data types.

Table 8-5

Mapping of Sybase data types to Actuate SQL data types

Sybase data type	Actuate SQL data type	Compiled to Sybase data type	Sybase data type limitations
CHAR	VARCHAR	NVARCHAR	Sybase NVARCHAR has a maximum length of 255 characters.
DATETIME	TIMESTAMP	DATETIME	Sybase DATETIME stores values from January 1, 1753. The accuracy of dates is to one three-hundredths of a second (3.33 milliseconds).
DECIMAL	DECIMAL	DECIMAL	The maximum number of significant digits (precision) for Sybase DECIMAL is 38.
DOUBLE PRECISION	DOUBLE	FLOAT
FLOAT	DOUBLE	FLOAT
INT	INTEGER	INTEGER
MONEY	DECIMAL	DECIMAL	The maximum number of significant digits (precision) for Transact-SQL DECIMAL is 38.
NCHAR	VARCHAR	NVARCHAR	Sybase NVARCHAR has a maximum length of 255 characters.
NVARCHAR	VARCHAR	NVARCHAR	Sybase NVARCHAR has a maximum length of 255 characters.
REAL	DOUBLE	FLOAT
SMALLDATETIME	TIMESTAMP	DATETIME	Sybase DATETIME stores values from January 1, 1753. The accuracy of dates is to one three-hundredths of a second (3.33 milliseconds).
SMALLINT	INTEGER	INTEGER
SMALLMONEY	DECIMAL	DECIMAL	The maximum number of significant digits (precision) for Sybase DECIMAL is 38.
TINYINT	INTEGER	INTEGER
VARCHAR	VARCHAR	NVARCHAR	Sybase NVARCHAR has a maximum length of 255 characters.

Copyright Actuate Corporation 2012