TL;DR

You have to have the required collation for the server, ent database(s) and reg database if you are using MC to any great degree.

If you are using/are willing to use MCe for any places you run into problems while running, then we have a fix that works for the current MC 2025 upgrade process.

We may create fixes for specific collation errors. These fixes may or may not work in future versions. Creating the fix does not make us responsible for a new fix - they are a 'buy time' to switch some users to MCe and/or a version of MC that doesn't have the specific issue.

Details

The MC 2025 upgrade has in the release we are using two Collation error bugs. The APS/MCC/ITIQPro upgrade package has fixes for them.

We had previously (2025 or 2024) supplied Accruent with a fix Collation bug in PMs and they applied the fix in their MC 2025 upgrade for that specific location. Update: They removed their fix, but we provide our fix.

In 'our' MC 2025 upgrade we have fixed it broader than just that one location, so customers of ours shouldn't have a problem with this during the upgrade.

We have more testing to do as upgrades come out over the next few years, but we have a concern that as Accruent is moving to using temp tables, and they are currently ignoring at least some collation issues, this may require that you use MCe Admin1/WO4/WO7 for any areas that MC has collation bugs, or the db server must be set to the USA collation and our 'fixes' may be a patch on the 'first' issues, not a solution. Stay tuned. If you want to be notified of updates, send a message to [email protected] to be put on a notification list.

During the upgrade, we see that Accruent has done more that requires the correct collation in the server (creating temp tables/sps), and while we fixed it in the upgrade, there may be more.

We have reports from at least one question that having the wrong collation causes PMs to fail, we highly suspect that yes, if you have the wrong collation sequence no matter which you have, it will fail. But we do not test on known bad setups so we are not planning on testing this. Update 2026.07.23 if you are running into wrong collation errors for PMS, see: MC 2025 PM Collation fix