Should we change all JIRA's database tables character set to utf8 and collation to utf8_bin?

[EJ Victoria]

As per https://confluence.atlassian.com/display/AGILEKB/Optimising+Performance database collation must be properly set. Is the correct character set utf8 and collation utf8_bin? Thanks. We are using JIRA 6.3.4 and MySQL.

[Radu Dumitriu]

Yes.

https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+MySQL

https://confluence.atlassian.com/display/DOC/Configuring+Database+Character+Encoding (same for JIRA)

[Dzintars]

In many cases converting is required.
I was using this comandline to convert existing database from utf8_general_ci to utf8_bin:

DB="your_database_name"; ( echo 'ALTER DATABASE `'"$DB"'` CHARACTER SET utf8 COLLATE utf8_bin;'; mysql "$DB" -e "SHOW TABLES" --batch --skip-column-names | xargs -I{} echo 'ALTER TABLE `'{}'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;' ) | mysql "$DB"

 Open terminal, paste this in and hit enter. Wait little bit while job is done. TA-DAA!!

[Radu Dumitriu]

depends. IMHO you need to change it if you plan to support multiple langs.

[EJ Victoria]

The reason for the question is upon checking our JIRA 6.3.4's database tables, some has latin1_swedish_ci and utf8_unicode_ci for collations. Is this a bad thing? Thanks.