SQL Server Data Types in Microsoft Dynamics NAV

Every available 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.