How do I set up UTF-8 setting so that we can use Greek letters in JIRA Software text fields?

[Brian Alden]

Our company uses Greek letters for mathematical communication but we are not able to use the use the these characters in our JIRA Issues without JIRA throwing a error message.  We have not altered the original JIRA server initial installation settings per UTF-8 encodings.  Anyone have a solution or suggestion?

[Boris Berenberg - Atlas Authority]

You will need to ensure your DB and Jira's connection to it are set up correctly. It sounds like the DB was set up with the wrong collation.

[Brian Alden]

Thanks Boris.  Yes, upon further investigation, I have discovered that there is a collation error with our MySQL DB.  I am working with JIRA Support to resolve the issue.  I will post our discoveries and resolution when we get things fixed.

[Brian Alden]

I just want to update the Community on the resolution to Database issue concerning UTF-8 encoding and collation.   First, we discovered that not only was the collation of the database incorrect but we were using a non-recommended MySQL database (MariaDB).  We mIgrated to a MSSQL database with a Latin1 collation, work like a charm.  Thanks to Boris and Atlassian for their support, they had it right.