Navision 360 is supposed to take the sort order from the SQL server when a database is created. The sql server has been setup with the default settings and the sort code Latin1_General_CI_AS. However all the databases are being setup with SQL_Latin1_General_CP850_BIN. Could anyone explain why this is occuring and how to rectify the issue.
Attain will not take the Collation from the default server collation if that collation is a Windows Collation - its name does NOT begin with SQL_, as with your case (it only follows it if it is a SQL collation) Instead it will use the first collation in its list that matches your code page, when you create the database. When you create a database you should pay attention to the collation you want by setting it in the Collation tab. In 3.70 Windows Collations are supported - not in 3.60.