Incorrect database collation setting can cause errors/failures in the Git Integration for Jira application.
Jira admins will see a message similar to the one below in the Jira log:
Health Check: Collation
Is healthy: false
Failure reason: The database collation 'utf8_bin' and table collation 'utf8_bin' are not supported by Jira.
This check retrieves the collation of the database and determines if it is within the list of collations supported by Atlassian. The Check will not assess collation when using an embedded (H2/HSQL) database and will fail if it cannot successfully identify the database (MariaDB is being used, for example). It fails if the collation does not match what we expect, or it cannot be retrieved due to an exception checking it. This health check does not report any warnings for Postgres database users. If you experience an error on this health check, the steps in the resolution should be applied.
Follow instructions from Atlassian:
Microsoft SQL Server: Health Check: Database Collation in Microsoft SQL Server
PostgreSQL: Health Check: Database Collation in PostgreSQL
Oracle: Health Check: Database Collation in Oracle
More articles about troubleshooting, workarounds and solutions
Health Check: Database Collation (this page)