Transact-SQL data type | Actuate SQL data type | Compiled to Transact-SQL data type | Transact-SQL data type limitations |
CHAR | VARCHAR | NVARCHAR | Transact-SQL NVARCHAR has a maximum length of 4000 characters on SQL Server. |
DATETIME | TIMESTAMP | DATETIME | Transact-SQL 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 Transact-SQL DECIMAL is 38. |
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 | Transact-SQL NVARCHAR has a maximum length of 4000 characters on SQL Server. |
NVARCHAR | VARCHAR | NVARCHAR | Transact-SQL NVARCHAR has a maximum length of 4000 characters on SQL Server. |
REAL | DOUBLE | FLOAT | |
SMALLDATE TIME | TIMESTAMP | DATETIME | Transact-SQL 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 Transact-SQL DECIMAL is 38. |
TINYINT | INTEGER | INTEGER | |
VARCHAR | VARCHAR | NVARCHAR | Transact-SQL NVARCHAR has a maximum length of 4000 characters on SQL Server. |