Microsoft Dynamics NAV - C/SIDE Solution Development -

Microsoft Dynamics NAV – C/SIDE Solution Development

Locus IT ServicesMicrosoft Dynamics NAV – C/SIDE Solution Development

Lesson 3: Collation Options

Collation Options

Collation Options : SQL Server supports several collations. A collation encodes the rules that govern the correct use of characters for either a language, such as Macedonian or Polish, or an alphabet, such as Latin1_General (the Latin alphabet that is used by Western European languages). Microsoft Dynamics NAV 2013 only supports the latest

Windows collations. Any database that is upgraded by Microsoft Dynamics NAV 2013 is converted to the most recent corresponding Windows collation. Each SQL Server collation specifies the following three properties:

  • The sort order to use for Unicode data types (nchar, nvarchar, and ntext). A sort order defines the sequence in which characters are sorted, and the way that characters are evaluated in comparison operations.
  • The sort order to use for non-Unicode character data types (char, varchar, and text).
  • The code page that is used to store non-Unicode character data.

You can specify SQL Server collations at any level. Each instance of SQL Server has a defined default collation. This is the default collation for all objects in that instance of SQL Server, unless otherwise specified. Each database can have its own collation. This can differ from the default collation. You can specify separate collations for each column, variable, or parameter. Microsoft Dynamics NAV sets the database default collation for reference only. All columns that are created by Microsoft Dynamics NAV explicitly has the collation set.

It is a good practice to set the collation as generic as possible to the language that is most common to users. If all users speak the same language, set up SQL Server with a collation that supports that language. For example, if all users speak French, define a French collation on SQL Server. If users speak multiple languages, define a collation that best supports the requirements of the various languages. For example, if the majority of users speak western European languages, then Latin1_General collation is the best option.

Collation settings are defined in the Microsoft Dynamics NAV Development Environment when a database is created. You can change it afterward with some limitations.

Locus IT Project Management Office
What’s it?