Sage 300 2021 PU5 - SQL 2016
I think I know the answer to this (no) but can the System DB be a different collation method than the company DB? I ask since a new company is being brought onboard from an old Sage version environment where the company DBs are Chinese_PRC_Stroke_90_CI_AI (Chinese and HK entities) and the shared System DB that I would like to incorporate these entities into is SQL_Latin1_General_CP1_CI_AS. I was hoping to avoid having to maintain a second System DB but, based on my understanding and experience, I don't thing Sage will work with a mixture of collation methods.
Thoughts?
Thank you.