News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Bug in default Collation

Microsoft Dynamics NAV (Archived)

Bug in default Collation

(0) Share

Report

Report

Posted on by TorbenMikkelsen

When creating a new database from NAV2015 to SQL server with Danish Regional Settings, the database is created with Danish_Greenlandic_CI_AS collation. You can only choose Danish collation.

The default collation on a “Danish regional language ” SQL server is Danish_Norwegian_CI_AS.

This will give a lot of issues, when you have integration from other Systems, and downgraded Performance as the Server Collation is different.

Will you please try to fix this, because it will be a big issue to a lot of customers.

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

TorbenMikkelsen on at

Like (0)

Report

RE: Bug in default Collation

It will work, only problem is that we cant find anywhere if it is supported.
keoma 32,675 on at

Like (0)

Report

RE: Bug in default Collation

try to change the collation in smss tool, database properties, options.

does this solve your issue?
Suggested answer

Miguel Llorca User Group Leader on at

Like (0)

Report

RE: Bug in default Collation

Hi Torben, I'll send this suggestion to the NAV team. Thanks for your feedback.

Regards!

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans