The BigInteger data type stores very large whole numbers within the range

-9,223,372,036,854,775,807 to 9,223,372,036,854,775,807.

The Char data type stores a single character as a value in the range 0 to 255. This data type can be freely converted between a number and a character. This means that you can use the same mathematical operators as you can with a variable of a numerical data type.

For example, you can assign a constant string of length 1 to a char variable.

	Copy Code
C := "A";

You can also assign a single char in a Text, Code, or Binary data type variable to a Char variable.

	Copy Code
C := S[2];

You can also assign a numeric value to a char variable. This will cause the char variable to contain the character from the ASCII character set that corresponds to the numeric ASCII code.

	Copy Code
C := 65;

In the Classic client, the Decimal data type denotes decimal numbers ranging from -10+E63 to +10+E63. The exponent ranges from -63 to +63. Decimal numbers are held in memory with 18 significant digits. Although you can store decimal numbers ranging from -10+E63 to +10+E63, you cannot specify a number outside the range +/- 999,999,999,999,999.99 in the UI or in code.

In SQL Server, you can store a decimal number with up to 18 digits and 20 decimal place digits. However, if a number is more than 15 digits, then you cannot enter it in SQL Server or view it in the UI.

In the RoleTailored client, you can store a decimal number with up to 29 digits and precision of 18 digits.

In general, we recommend that you construct decimals that operate on numbers within the range of +/- 999,999,999,999,999.99. Although you can construct larger numbers in some cases, overflow, truncation, or loss of precision can occur.

The Duration data type represents the difference between two DateTimes, in milliseconds. For example, you can calculate the difference between two DateTimes by running the following code. This example requires that you define the following variables.

This example is run on a computer with the Current Format in the Regional and Language Options set to English (United States).

	Copy Code
DateTime1 := CREATEDATETIME(010109D, 080000T); // January 1, 2009 at 08:00:00 AM DateTime2 := CREATEDATETIME(050509D, 133001T); // May 5, 2009 at 1:30:01 PM Duration := DateTime2 - DateTime1; MESSAGE(FORMAT(Duration));

The message window displays the following:

124 days 4 hours 30 minutes 1 second

The Integer data type stores integers between -2,147,483,647 and 2,147,483,647.

The Option data type denotes an option value. The Option type is a zero-based enumerator type. Therefore, you can convert option values to integers. For example, assume that Number is a numeric variable and that Type denotes a field of type Option in the Purchase Header table. The following statement converts the option value to a number.

	Copy Code
Number := "Purchase Header".Type;

In another example, the following code shows how to use the possible values of an option field as constants.

	Copy Code
"Purchase Header".Type := "Purchase Header".Type::Invoice;

The Code data type denotes a special type of text string. When a given text is assigned to a variable of data type Code, the text is changed to uppercase and any leading and trailing spaces are removed. You can index any character position in a string, for example, A[65]. The resulting values will be of the Char data type. The length of a variable of data type Code always corresponds to the number of characters in the text without leading and trailing spaces. The maximum length of a variable of data type Code is 1024 characters. The maximum length of a table field of data type Code is 250 characters.

The following table shows some typical examples of Code string assignments. In the following examples, it is assumed that the variable c is of data type Code, and has a maximum length of 4.

The Text data type denotes a text string. The length of the string ranges from 1 to 1024 characters. You can index any character position in a string, for example A[65] refers to the 65th character in the variable called A. The resulting values will be of data type Char. The length of a variable of data type Text corresponds to the number of characters in the text. For example, an empty text string has length 0.

The following table shows some typical examples of text strings. In these examples, it is assumed that the variable t is of data type Text and has a maximum length of 6.

When you use the Text and Code data types, it is important to distinguish between the maximum length of the string and the actual length of the string. The maximum length is the upper limit for the number of characters in the string. The actual length describes the number of characters used in the string. The STRLEN Function (Code, Text) and the MAXSTRLEN Function (Code, Text) illustrate this.

	Copy Code
t := 'AbC'; STRLEN(t); // Returns 3. MAXSTRLEN(t); // Returns 6. t := '12345'; STRLEN(t); // Returns 5. MAXSTRLEN(t); // Returns 6.

The possible values of Boolean data types are TRUE or FALSE.

The Date data type denotes dates ranging from January 3, 0001 to December 31, 9999. An undefined date is expressed as 0D. The undefined date is considered to be before all other dates. When you work with dates, you must consider the case in which a date is undefined. For example, if the due date for an invoice is not specified and you create a report that displays all due invoices on a certain date, then you must handle the undefined date. Otherwise, the invoice with the unspecified date will appear to be long overdue, which may not be true.

All dates have a corresponding closing date. The closing date for a given date is regarded as a period following the given date but before the next normal date. A closing date is therefore sorted immediately after the corresponding normal date but before the next normal date.

The DateTime data type denotes a date and the time of day. The DateTime is stored in the database as Coordinated Universal Time (UTC). UTC is the international time standard (formerly Greenwich Mean Time, or GMT). Zero hours UTC is midnight at 0 degrees longitude. The DateTime is always displayed as local time in Microsoft Dynamics NAV. Local time is determined by the time zone regional settings used by your computer. You must always enter DateTimes as local time. When you enter a DateTime as local time, it is converted to UTC using the current settings for the time zone and daylight saving time.

There is only one constant available when you use this data type: undefined datetime, which is expressed as 0DT.

The range of a DateTime depends on whether you are using the Microsoft Dynamics NAV Classic Database Server, or SQL Server.

• Classic Database Server

  The earliest permitted DateTime is January 3, 0001, 00:00:00.000.

  The latest permitted DateTime is December 31, 9999, 23:59:59.999.

• SQL Server

  The earliest permitted DateTime is January 1, 1753, 00:00:00.000.

  The latest permitted DateTime is December 31, 9999, 23:59:59.999.

  Any DateTimes that are not within this range and that you try to enter or construct by, for example, adding a DateTime to a Duration, are regarded as undefined DateTimes and give an error message.

  Undefined dates in Microsoft Dynamics NAV are stored as January 1, 1753, 00:00:00.000, which is the earliest permitted DateTime in SQL Server.

The Time data type denotes a time ranging from 00:00:00 to 23:59:59.999. An undefined time is expressed as 0T.

For more information about the Automation data type, see Extending Microsoft Dynamics NAV Using COM.

The BigText data type contains large text documents. Data of the BigText data type cannot be displayed in the debugger or in a message window. However, you can use the BigText functions to extract part of a big text and place it in a normal text string that can be displayed. The BigText functions are:

• ADDTEXT Function (BigText)

• GETSUBTEXT Function (BigText)

• LENGTH Function (BigText)

• READ Function (BigText)

• TEXTPOS Function (BigText)

• WRITE Function (BigText)

The maximum length of a BigText variable is 2147483647 characters. This is the equivalent of 2 gigabytes (GB).

A BLOB is a Binary Large Object. Variables of this data type differ from normal numeric and string data type variables in that they have a variable length. BLOBs are used to store memos (text), bitmaps (pictures), or user-defined types. The maximum size of a BLOB is often determined by your system’s disk storage capacity. The upper limit is 2GB.

The Codeunit data type stores codeunits. A codeunit can contain a number of user-defined functions.

The DateFormula data type contains a date formula that has the same capabilities as an ordinary input string for the CALCDATE function. The DateFormula data type is used to provide multilanguage capabilities to the CALCDATE function.

The Dialog data type stores dialog windows. A number of functions are available for manipulating dialogs.

The File data type provides access to operating system files.

The FieldRef data type identifies a field in a table and gives you access to this field. The FieldRef object can refer to any field in any table in the database.

The Form data type stores forms. This data type can contain a number of simpler elements called controls. Controls are used to display information to the user or to receive user input.

The GUID data type gives a unique identifying number to any database object.

The GUID data type is a 16-byte binary data type. This data type is used for the global identification of objects, programs, records, and so on. The most important property of a GUID is that each value is globally unique. The value is generated by an algorithm, developed by Microsoft, which assures this uniqueness.

The GUID is a 16-byte binary data type and can be logically grouped into the following subgroups: 4byte-2byte-2byte-2byte-6byte. The standard text representation is {12345678-1234-1234-1234-1234567890AB}.

The InStream and OutStream data types enable you to read from or write to files and BLOBs. In addition, you can use InStream and OutStream to read from and write to objects of the Automation and OCX data types.

The KeyRef data type identifies a key in a table and the fields in this key. This gives you access to the key and the fields it contains. The KeyRef object can refer to any key in any table in the database.

For more information about the OCX data type, see Extending Microsoft Dynamics NAV Using COM.

The Page data type stores pages that can contain a number of simpler elements called controls.

The Record data type consists of a number of simpler elements called fields. A record corresponds to a row in a table. Each field in the record is used to store values of a certain data type. The fields are accessed using the variable name of the record (often the same as the name of the corresponding table), a dot (a period), and the field name. A record is typically used to hold information about a fixed number of properties.

The RecordID data type contains the table number and the primary key of a table. You can store a RecordID in the database but you cannot set filters on a RecordID.

The RecordRef data type references a record in a table. Typically you use a RecordRef in functions that must apply to all tables, not to a specific table.

If one RecordRef variable is assigned to another RecordRef variable, then they both refer to the same table instance.

The Report data type stores reports. It can contain a number of simpler elements called controls. Controls are used to display information to the user.

The TableFilter data type applies a filter to another table. This data type can only be used when you are setting security filters from the Permission table.

The Variant data type can contain the following C/AL data types:

• Record

• File

• Action

• Codeunit

• Automation

• Boolean

• Option

• Integer

• Decimal

• Char

• Text

• Code

• Date

• Time

• Binary

• DateFormula

• TransactionType

• InStream

• OutStream.