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