-
Type:
Bug
-
Resolution: Not a bug
-
Priority:
Low
-
None
-
Affects Version/s: 6.4.11, 7.0.0
-
Component/s: Installation
-
6.04
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)
- has a derivative of
-
JRASERVER-59501 Display tables with incorrect collation in Health Checker user interface
- Closed
