Different Collation per. Company – anyone tried it?

pdj
pdj Member Posts: 643
edited 2015-03-16 in SQL General
(NAV 2009 Classic.)
We are having issues with a database that is going to be used from several countries around the globe – both Europe and Asia. Each country has their own Terminal Server set in local non-unicode codepage. Each company is only used in one country, but we are unable to store local chars unless the collation of the database match the language of the country.

We are therefore considering batch job that changes the collation of all Text fields in the tables belonging to each company. (we are also considering Code fields, but we don’t think it will be necessary) We foresee a few issues , but nothing serious:
    Not handling shared tables Might cause issues if we access the SQL tables directly for JOINs or replication etc. We need to run the batch job each time a FOB is imported. Does not allow object names or fields names to be localized

Has anyone tried this approach or have any objections or recommendation about it?
Regards
Peter

Comments

  • kine
    kine Member Posts: 12,562
    Have you taken into account possibility like upgrade to NAV 2013 with the Unicode support? Of course, I know that it could cost you big money if you have too much customized database, but I want to know if you have though about that... because I will never go the way you are trying to go...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • pdj
    pdj Member Posts: 643
    Yes, we know the problem will be solved in the new NAV versions supporting Unicode.
    However; the customer is currently using multiple different customized NAV databases, and one of the first steps is to merge all these databases into one before we expect to upgrade them to NAV2015 or NAV2015R2 at a later point.

    I must also admit I didn't like this approach in the beginning, but after having thought about it, I doubt it will cause any major problems.
    That's why I would like to know which issues you expect or fear we might encounter?
    Regards
    Peter
  • kine
    kine Member Posts: 12,562
    What about tables which are DataPerCompany=No? Like users (some countries have local characters in windows logins), roles and permissions...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • pdj
    pdj Member Posts: 643
    Yes, that was what I meant with "Shared tables", which we don't expect to be a problem keeping with English chars.
    We just need to be able to name masterdata like G/L Accounts and Customers and Vendors and Items and Sales People etc. with national chars.
    Regards
    Peter
  • pdj
    pdj Member Posts: 643
    Just found a tool claiming to solve the problem:
    http://www.octocon.de/index.php?article_id=12&clang=1
    Anyone tried that, or know how it solves the problem?
    Regards
    Peter

Categories