Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Collation of the Compa...
Microsoft Dynamics NAV (Archived)

Collation of the Company Database

(0) ShareShare
ReportReport
Posted on by Ahmad_Safadi 369

I have created a new company and completed the setup. As I am checking the collation, it is Latin Case Sensitive, Accent Sensitive. Although, the SQL Server collation is Arabic_CI_AI

My question is,

Where to specify the collation while creating a new Dynamics NAV database ? It seems there is no option.

Furthermore, when I go to the Development Environment, and click on Alter Database. I try to change the collation, but it says you can not because the "Validate Collation" should already be checked before installation

Your help Please.

*This post is locked for comments

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Collation of the Company Database

    You do not have to do a new installation. You can simply do it using Development environment.

    Click on File -> Database -> New

    Then it will ask for your Authentication.

    Then click Ok

    In the next open window you can set the DB settings. Under the Collation tab you can set the Collation you required.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Collation of the Company Database

    Try this walkthrough of creation of new databases: msdn.microsoft.com/.../hh165743(v=nav.90).aspx

    Check collation tab: msdn.microsoft.com/.../hh168537(v=nav.90).aspx

  • Ahmad_Safadi Profile Picture
    Ahmad_Safadi 369 on at
    RE: Collation of the Company Database

    Then my question is, supposing I am doing a fresh installation now. From where can I configure the collation of the new company ?

    I can't find any option under Server Components, Database Components nor client components

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Collation of the Company Database

    I think this might answer your question :

    If you set the Validate Collation check box, then collation languages that run with a different non-Unicode code page from your system non-Unicode code page are filtered out of the Language drop-down list. An example scenario of when you might want to choose a collation language that has a different code page from your system code page is if you want to prepare a Japanese database on a Danish computer.

    You cannot change the collation directly in the current database. To change the collation, you must create a new database that uses the correct collation, and then export the data from the old database and import it to the new database. For more information, see How to: Alter Databases

    https://msdn.microsoft.com/en-us/library/hh168537(v=nav.90).aspx

  • Ahmad_Safadi Profile Picture
    Ahmad_Safadi 369 on at
    RE: Collation of the Company Database

    Guys

    It seems you have not read my questions properly. I have followed the steps above, but there is a check box (Validate Collation) which is not checked. Once I click on process, a warning message pops up and prevents me from proceeding saying that "You can not change collation if the "Validate Collation" is not already checked. "

    Your assistance is highly appreciated

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Collation of the Company Database

    You can change the Collation using Dynamics NAV Development Environment.

    Steps :

    1. Open the Database using Development Environment

    2. Click on File -> Database -> Alter

    3. Under the Collation tab you can change the Collation.

    4. Click Ok, once you select the correct Collation

    * Make sure to do this when the DB is in single user mode to avoid conflicts.

  • Suggested answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: Collation of the Company Database

    Hi

    You can change the Collation from Development Environment, Before changing the collation Change the Database mode to "Single user", you can refer the below for How to change collation.

    blogs.msdn.microsoft.com/.../how-to-change-the-collation-on-a-microsoft-dynamics-nav-2013-r2-database

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans