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.
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.
Yes.
https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+MySQL
https://confluence.atlassian.com/display/DOC/Configuring+Database+Character+Encoding (same for JIRA)
depends. IMHO you need to change it if you plan to support multiple langs.
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!!
It looks like you're new here. Sign in or register to get started.
