MSSQL Collation Issue During Upgrade

We recently upgraded our gitea from 1.18 to 1.23 and we are now receiving an error in regards to database collation. Since we are using MSSQL, and according to the error presented, we can only do it via database alter commands.

It is easy enough to alter the database, but altering every single column, especially those with constraints, is a challenge and requires a lot of manual work.

Has anyone dealt with this before and has a good recommendation on an easier method for updating columns with constraints attached?

Did you try to accomplish a staggered upgrade, as workaround, yet? For example, from 1.18 to 1.19, from 1.19 to 1.20, etc…?

Is it possible the staggered upgrade would resolve the issue instead of going directly to 1.23?

I learned we did do a staggered upgrade when this issue arose.