Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-59427

Incorrect warning about the use of utf8_general_ci collation on Mysql (Linux).

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a bug
    • Low
    • None
    • 6.4.11, 7.0.0
    • Installation

    Description

      Hi.

      Following JRA-43514, we have the same problem with MySQL on Linux

      The table collation: 'utf8_general_ci' is unsupported by JIRA. The Database collation: 'utf8_bin' is supported by JIRA.

      Software

      • MySQL 5.6.26-2
      • Jira: 6.4.11
      • CentOS 6.5.

      Test

      mysql> SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA LIKE "jira" AND COLLATION_NAME like "utf8_bin";
      +----------+
      | count(*) |
      +----------+
      |      965 |
      +----------+
      1 row in set (0.01 sec)
      
      mysql> SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA LIKE "jira" AND COLLATION_NAME like "utf8_general_ci";
      Empty set (0.02 sec)
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              1f46000eead1 David Álvarez
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: