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 7‑5 shows how Sybase data types map to Actuate SQL data types.
Table 7‑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.