From the Microsoft Dynamics NAV Blogs: Upgrade database error; New item categories; Embed NAV in SharePoint; Restart a ‘frozen’ job

From this week's Microsoft Dynamics NAV blogs:

• Quick Fix: There Is no System Code Page on Your Computer that Matches the Code Page of the Collation for the Database
• The New Item Categories Feature Replaced the Product Group Feature in Dynamics NAV 2017
• Embedding Microsoft Dynamics NAV and Its Web Parts in SharePoint Online
• How to Restart a Job in ‘Error' or ‘Frozen Completed' Status

Quick Fix: There Is no System Code Page on Your Computer that Matches the Code Page of the Collation for the Database

On his TharangaC - Dynamics NAV Blog, Tharanga Chandrasekara wrote that people who are still using an old version of Microsoft Dynamics NAV, or are trying to a newer version, might see the following error message when they open up the database from the classic client.

Microsoft Dynamics NAV Classic---------------------------

There is no system code page on your computer that matches the 850 code page of the SQL_Latin1_General_CP850_CI_AS collation for the XXXXXXXXXXXXXXXX database

Your system code pages are: ANSI: 1252, OEM: 437.

Ensure that the Regional Options of the computer use the correct system language and locale for the code pages to match.

You can also disable the 'Validate Collation' setting for this database. It is possible that certain text data will not be converted correctly when stored in the database.

Click OK to disable the 'Validate Collation' setting and continue to use the database, or click Cancel to exit.

---------------------------OK Cancel ---------------------------

You received this error message because your database collations are different from your computer collation, he said. You can have a quick ...