This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 1.
The third of the new functionality in the Productive with Microsoft 365 section is Allow application and tenant databases to differ in collation.
On-premises customers can use many different collations for their environment, driven by different requirements for country or different ordering/strings operations. In a multitenant setup, until now it wouldn’t be possible to cohost tenant databases with different collations served by the same Business Central server (NST). With this release, you can easily cohost these databases on the same setup, and therefore administer such multitenant/multilanguage setups more efficiently.
Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Apr 2023
General Availability: Apr 2023
The collation of a database controls the ordering and equality operations of strings. In earlier versions of Business Central, a multitenant installation required the application database and the tenant databases to have the same database collation. In this release, the Business Central server (the NST) will work even though the application and tenant databases use a different database collation.