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 |