Data type translation table
The generic data types used in this section are not specific to any database type.
The SQL Server types nvarchar and ntext are preferred to varchar and text because they allow the use of non-Ascii characters.
This table describes the data types:
| Generic type | SQL Server type |
|---|---|
| Integer | int |
| BigInteger | bigint |
| String(n) | nvarchar(n) (limited to 2000) |
| nvarchar(MAX) | |
| Real | real |
| DateTime | datetime |
| Boolean | bit |
| Text | ntext |