Export (0) Print
Expand All

SQL Server Data Types

Microsoft Dynamics NAV 2013

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

Show:
© 2014 Microsoft