Hey everyone, I’m stuck with a problem while setting up Jira with a MySQL database. Every time I try to run it, I get this error:
Caused by: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
I’m not sure what’s causing this or how to fix it. Has anyone run into this before? Any ideas on what might be going wrong with the collations? I’d really appreciate some help figuring this out. Thanks in advance!
ugh, that error sounds like a pain! have u checked ur database settings? might be a mismatch between ur jira config and mysql character set. try settin both to utf8mb4 and see if that helps. good luck mate!
I’ve dealt with this exact issue before, and it’s a real headache. The problem is definitely related to character encoding mismatches between Jira and MySQL. Here’s what worked for me:
First, check your MySQL configuration file (my.cnf or my.ini) and ensure these lines are present:
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
Then, you’ll need to alter your database and tables to use the correct collation. Run these SQL commands:
ALTER DATABASE your_jira_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE your_table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Repeat the ALTER TABLE command for all tables in your Jira database.
Finally, update your Jira configuration to use UTF-8 encoding. This should resolve the collation mismatch error.
Remember to backup your database before making these changes. Good luck!
I encountered a similar issue during my Jira setup. The problem likely stems from inconsistent character encodings between Jira and MySQL. To resolve this, ensure your MySQL server uses UTF-8 encoding throughout. You can modify your my.cnf file to set the default character set and collation to utf8mb4. Additionally, check your Jira database configuration and align it with the MySQL settings. If issues persist, consider recreating the database with proper UTF-8 encoding from the start. This approach solved the problem for me and should work for your setup as well.