Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-59378

Log messages indicate Latin1_General_CI_AI shown as unsupported database collation for MySQL while health check passes

    XMLWordPrintable

    Details

      Description

      Summary

      Latin1_General_CI_AI shown as unsupported database in JIRA's logs:

      The message in atlassian-jira.log reads:

          ****************************************************************************************************
          You are using an unsupported mssql collation: Latin1_General_CI_AI. This may cause some functionality to not work.
          Please use SQL_Latin1_General_CI_AI or SQL_Latin1_General_CP437_CI_AI as the collation instead.
          ****************************************************************************************************
      

      Steps to Reproduce

      1. Create Latin1_General_CI_AI database in Microsoft SQL Database.
      2. Connect JIRA to the database.
      3. Restarting JIRA shows the error in the logs.

      Expected Results

      The logs should not fail on this collation for Microsoft SQL Server.

      Actual Results

      The collation is reported as unsupported. Latin1_General_CI_AI is supported.

      Workaround

      Ignore the Error in the logs and confirm the supported collation with the JIRA Instance Health Add-on..

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              vshanmugam Vicknesh Shanmugam
              Votes:
              30 Vote for this issue
              Watchers:
              50 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: