Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Technical upgrade to 2...
Microsoft Dynamics NAV (Archived)

Technical upgrade to 2013 changes collation of database

(0) ShareShare
ReportReport
Posted on by Gunnar Sundfær

During upgrade from 2009R2 to 2015, we had an issue. When we connect a 2013 developer client to the 2009R2 database, it asks to convert the database. After this (technical) convertion the collation have been changed from Danish_Norwegian_CI_AS to Danish_Greenlandic_100_CI_AS.
Before the upgrade step, the database was set to Windows collation - Danish, Norwegian.
The consequence are that some special norwegian letters are unreadable. As far as I'm concerned, we have no control over this upgrade step.
Have anybody experienced anything similar?
Does anyone have solution for us?

PS: We tried to put the database in single user mode, changed collation to Norwegian. After starting service tier and wait for synchronization to finish, the data are still unreadable.

Regards, Gunnar

*This post is locked for comments

  • Gunnar Sundfær Profile Picture
    Gunnar Sundfær on at
    RE: Technical upgrade to 2013 changes collation of database

    It only partly answered my question, so I was reluctiant to verify.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Technical upgrade to 2013 changes collation of database

    pls verify................

  • Gunnar Sundfær Profile Picture
    Gunnar Sundfær on at
    RE: Technical upgrade to 2013 changes collation of database

    Thank you all for your tips.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Technical upgrade to 2013 changes collation of database

    Please check the below link for Best Practices Tips and Tricks for Upgrading to Dynamics NAV.

    community.dynamics.com/.../best-practices-tips-and-tricks-for-upgrading-to-dynamics-nav-2013-r2-or-dynamics-nav-2015-part-2

  • Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Technical upgrade to 2013 changes collation of database

    Please check Collation Issues and Data conversion issues in below link

    blogs.msdn.com/.../best-practices-tips-and-tricks-during-upgrade-to-dynamics-nav-2013-r2-or-dynamics-nav-2015-part-2.aspx

  • Gunnar Sundfær Profile Picture
    Gunnar Sundfær on at
    RE: Technical upgrade to 2013 changes collation of database

    Forgot to mention: We tested some more, and found out that the data in the tables looked ok with norwegian letters and correct sort order. Only trouble with captions in objects.

  • Gunnar Sundfær Profile Picture
    Gunnar Sundfær on at
    RE: Technical upgrade to 2013 changes collation of database

    Yes, it was in this step 8 it changed collation for some reason. As I mentioned, we tried to do the next step (single mode, alter database to new collation), but it didn't look right at first sight. All the table the captions inside the objects still have special norwegian letters are which shows up wrong. We also see in SQL MS that the collation are still set to the wrong setting at table/field level. We tested some more, and found out that if we import all unmodified objects again as FOB, and saved/compiled all the changed objects again, then all the captions are ok. We are going to go ahead with this solution, but please comment if you have any knowledge of this case.

    Regards, Gunnar

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Technical upgrade to 2013 changes collation of database

    follow

    msdn.microsoft.com/.../hh168530(v=nav.71).aspx (step 8)

    alter database

    msdn.microsoft.com/.../hh165364(v=nav.71).aspx

    msdn.microsoft.com/.../hh168537(v=nav.71).aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans