SQL Server Data Types
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.