Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Could Navision run wit...
Microsoft Dynamics NAV (Archived)

Could Navision run with different collation in the same box?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I need to reduce cores' number all over the Vmware organization for monetary issues. I am planning to join different countries in just an Always On.

We obviously can marry 07 and 05 Always On but I wonder myself how to join 12 and 20 when they have different collation. is there any workaround for TEMPDB?

07. Turkey> Latin1_General_CI_AS
12. Russia> Cyrillic_General_CI_AS
20. Poland> SQL_Polish_CP1250_CI_AS
05. Australia, New Zealand and India> Latin1_General_CI_AS

Thanks in advance,

*This post is locked for comments

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Could Navision run with different collation in the same box?

    Interesting choice for Turkey, though...

    Check this thread, would that be helpful? www.sqlskills.com/.../changing-database-collation-and-dealing-with-tempdb-objects

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: Could Navision run with different collation in the same box?

    Hi Enric,

    I have limited experience with this one but as far as i know if you change the database collation, then the collation of objects in the database is changed except for tables that have the LinkedObject property set to Yes. You must manually re-create these objects. For example, you can script them in SQL Server Management Studio.

    So if you want to join 12 and 20 when they have different collation then i think you can still use the collate clause in a query...

    //***************

    select sone_field collate SQL_Latin1_General_CP850_CI_AI

     from table_1

       inner join table_2

         on (table_1.field collate SQL_Latin1_General_CP850_CI_AI = table_2.field)

     where whatever

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans