Do I need to re-index JIRA if I alter the collation on tables in MySQL

[Cyril Egan]

After upgrading from JIRA 6.1.7 to 7.0.10.  The support tools plugin reports:

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

I am using a MySQL database.  If I run the scripts to view the collation of my database tables I can see that some are using a collation of "utf8_general_ci" and some are using "utf8_bin".  (It looks like the tables from JIRA 6.1.7 are using utf8_general_ci and new tables created by the upgrade to JIRA 7 are in utf8_bin.)

QUESTION:

If I change the collation do I need to re-index JIRA afterwards?

Note I plan to shutdown JIRA and backup the database before changing the collation but I'm just wondering if a re-index is required as well.

[Robert Dzido · Accepted solution]

No, you don't have to reindex it, but please do backup prior to collation change especially if your database contains non-english characters (like spanish, french, polish or russian). Sometimes national characters are lost.

[Cyril Egan]

Thanks Robert.