web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Invalid collation when...
Microsoft Dynamics NAV (Archived)

Invalid collation when converting a database

(0) ShareShare
ReportReport
Posted on by Fredrik Gustafsson ... 265

Hi!

Connecting to an old database with NAV2009 R2 classic client (6.00.33046).

I get the message that the database must be converted. Ok.

Then an error is displayed: "Invalid collation SQL_SwedishStd_Pref_CP1_CI_AI'.

Must collation be changed to a windows collation?

Why?

Best regards,

Fredrik Gustafsson

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at

    hi,

    look at this post

    msdn.microsoft.com/.../hh168530(v=nav.71).aspx  (NAV 2009)

    ....

    "Upgrades to the newest Windows collation. Utilizing SQL collations for the database is no longer supported in Microsoft Dynamics NAV 2013 R2. If your database has been using a SQL collation, or an out-of-date Windows collation, the development environment will offer to perform a collation upgrade alongside the Unicode upgrade"

  • Fredrik Gustafsson @Tectura Profile Picture
    Fredrik Gustafsson ... 265 on at

    Thanks for the answer.

    I know this is new requirements for NAV2013R2. But this is NAV2009R2 and I am just trying to apply a hotfix upgrading runtime from 6.00.32384 to 6.00.33046. It was unexpected to be forced to change collation at the same time.

    Regards Fredrik

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans