May i know below collation_name is wrong or correct? MySQL version is 5.7.
I did follow this How to Fix the Collation and Character Set of a MySQL Database, still having the error below.
Casper `utf8_bin` is not correct if you are using Jira 8+. You need to migrate your database to `utf8mb4_bin` to get rid of collation error in health check.
If you look closely on the page you have linked, there are queries to help you do this process.
hi, thanks for the reply, do you mean below queries?
i did the below queries , still getting the same out put ...
<span>SELECT</span> <span>CONCAT</span><span>(</span><span>'ALTER TABLE '</span><span>,</span> table_name<span>,</span> <span>' CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;'</span><span>)</span> <span>FROM</span> information_schema<span>.</span><span>TABLES</span> <span>AS</span> T<span>,</span> information_schema<span>.</span><span>`</span><span>COLLATION_CHARACTER_SET_APPLICABILITY</span><span>`</span> <span>AS</span> C <span>WHERE</span> C<span>.</span>collation_name <span>=</span> T<span>.</span>table_collation <span>AND</span> T<span>.</span>table_schema <span>=</span> <span>'yourDB'</span> <span>AND</span> <span>(</span> C<span>.</span>CHARACTER_SET_NAME <span>!=</span> <span>'utf8mb4'</span> <span>OR</span> C<span>.</span>COLLATION_NAME <span>!=</span> <span>'utf8mb4_bin'</span>
When you run this query you will get bunch of queries as output, and later you need to run these queries to get desired output.
like below right?
after that which queries should i run ?
It looks like you're new here. Sign in or register to get started.
