I’m working on configuring a new Jira instance with MySQL as the backend database. During the setup process, I keep running into the same database error that’s blocking my progress.
The error message I’m seeing is:
Caused by: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
This seems to be related to character encoding or collation settings in MySQL, but I’m not sure what’s causing the mismatch. Has anyone encountered this issue before? What steps should I take to resolve this collation conflict and get Jira working properly with my MySQL database?
I encountered the same issue while setting up Jira with MySQL. It’s crucial to have a uniform collation for your database, as a mixture of latin1_swedish_ci and utf8_general_ci can lead to these errors. I recommend reviewing your database settings to ensure everything is using utf8mb4 as the standard collation type. Also, make sure the connection parameters in your Jira configuration include the necessary character encoding options. After applying these changes, it might be necessary to reset your database schema to fully resolve the conflicts.
same prob here last month! ya gotta fix ur MySQL collations, jira really doesn’t like mixed ones. best way is to just recreate the db with utf8mb4_bin collation. it’s faster than messin’ with old tables. saved me a lotta headache.
This happens when your MySQL server’s default collation doesn’t match what Jira wants. I hit this same issue during a migration - the existing database had mixed collations from old applications. MySQL’s latin1_swedish_ci default clashes with Jira’s utf8 requirements. Check your MySQL config file (my.cnf or my.ini) and set default-character-set to utf8mb4. Also make sure your Jira database connection string has the right charset parameters like characterEncoding=UTF-8. You’ll probably need to restart MySQL before trying the Jira setup again.