Configuring MySQL 4.1 to store non-ASCII characters

All Versions

JIRA 4.0 Beta Documentation

Index

Setting up a MySQL 4.1 database with JIRA to work with non-ASCII (non-English) characters

Please do the following:

  1. Create a new MySQL database using the following command:
    create database jiradb default character set utf8;
  2. Grant all the required permissions to the JIRA user for the database as described here.
  3. Change the JDBC URL in JIRA's datasource definition (conf/server.xml for JIRA Standalone) file to use the new database and be:
    jdbc:mysql://<your_server>:<port>/jiradb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8
    Please note the '&amp' XML escape for the ampersands in the url above is needed since it is specified in an xml file.
  4. Start JIRA and complete the setup process.

Please ensure that you create a new database using the correct character set and ensure that JIRA creates all its tables on startup without problems. This should allow you to work with all characters supported by Unicode, which covers most characters out there.

Please ensure that you are using the latest MySQL JDBC driver: http://dev.mysql.com/downloads/connector/j/3.1.html

Also please ensure you are using the UTF-8 character encoding in JIRA (Administration -> Global Settings -> General Configuration).
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.


Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.