Every available Microsoft Dynamics NAV data type is mapped to an appropriate SQL Server data type. The following table shows which SQL Server data type is used for the corresponding Microsoft Dynamics NAV data type.
| Microsoft Dynamics NAV Data Type | SQL Server Data Type |
|---|---|
BigInteger | BIGINT |
BLOB | IMAGE |
Boolean | TINYINT |
Code(n) | NVARCHAR(n), INTEGER, SQL_VARIANT |
Date | DATETIME |
DateFormula | VARCHAR(32) |
Decimal | DECIMAL(38,20) |
Duration | BIGINT |
GUID | UNIQUEIDENTIFIER |
Integer | INTEGER |
Option | INTEGER |
RecordID | VARBINARY(n) |
TableFilter | VARBINARY(252) |
Text(n) | NVARCHAR(n) |
Time | DATETIME |
Each of the SQL Server data types is created as NOT NULL except the IMAGE type, which allows NULL.
There are other SQL Server data types than those listed in the previous table. You can use and modify these from within Microsoft Dynamics NAV when you have created or altered SQL Server tables or views outside Microsoft Dynamics NAV.
Some of the SQL Server data types listed previously are compatible with other Microsoft Dynamics NAV data types. The following table shows the extended compatibility of SQL Server data types with Microsoft Dynamics NAV data types.
| Microsoft Dynamics NAV Data Type | SQL Server Data Type | |
|---|---|---|
Integer, Option | BIT | |
DateFormula | CHAR(n) | |
Code | INTEGER | |
Text(n), Code(n) | NCHAR(n) | |
BLOB | NTEXT | |
Decimal, Integer, Option, Boolean | NUMERIC(p,s), MONEY, SMALLMONEY, REAL, FLOAT(n), DECIMAL | |
Date | SMALLDATETIME | |
Integer, Option | SMALLINT | |
BLOB | TEXT | |
Integer, Option, Boolean | TINYINT | |