Bug in default Collation

(0) Share

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

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

Regards!

Was this reply helpful? Yes No
keoma 32,729 on at

Like (0)

Report

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

does this solve your issue?

Was this reply helpful? Yes No
TorbenMikkelsen on at

Like (0)

Report

It will work, only problem is that we cant find anywhere if it is supported.

Was this reply helpful? Yes No