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.
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!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
depends. IMHO you need to change it if you plan to support multiple langs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.