Wrong codepage using JIRA

I install *.bin latest version of Atlassian Jira to my server.

Console codepage is UTF-8, Latest LTS Ubuntu with updates.

When i create Issue and write russian characters at any form and press "Create" i will receive error.

In this error i see mysql error, where my characters write in bad view, like: /x09 etc.. Something wrong.

Please write me what i wiil do to fix them.

Error creating issue: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Issue][summary,привет][status,1][votes,0][assignee,milar][security,null][resolutiondate,null][type,4][timespent,null][id,10003][reporter,milar][project,10000][environment,null][created,2012-09-14 15:25:32.72][updated,2012-09-14 15:25:32.72][workflowId,10003][description,null][priority,3][timeestimate,null][duedate,null][timeoriginalestimate,null][watches,0][key,SITE-4] (SQL Exception while executing the following:INSERT INTO jiraissue (ID, pkey, PROJECT, REPORTER, ASSIGNEE, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, RESOLUTIONDATE, VOTES, WATCHES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xD0\xBF\xD1\x80\xD0\xB8...' for column 'SUMMARY' at row 1))

1 answer

1 accepted

This widget could not be displayed.


I believe that this problem is not related to the system codepage, but to the database codification and collation. If you are using MySQL, you can check the database codification with the following command:

mysql> use <jira_database_name>;
mysql> show variables where variable_name = 'character_set_database';

If your database is running with a non-UTF-8 codification, the best procedure IMO is create a new UTF-8 database and points JIRA for it. If you already has data on your current JIRA system, you will need to create a XML backup from it and re-import after that. So, for creating a MySQL database, you could use the following example:

mysql> create database jira514 character set utf8;

Best regards,
Lucas Timm

Yes. The problem is solved. But why jira by default do not create db character set in utf8 by default?..

Short/long answer: JIRA doesn't create a database with the needed codification just because it desn't create a database at all.

You'll need to create a database (or a Oracle tablespace) in beforehand for JIRA, and then it will create its tables over it. As per the Atlassian documentation, you must run JIRA on a UTF-8 or Unicode database:


We already provide the detailed instructions for setting correctly the codification, collation and the needed user permissions.

Best regards,
Lucas Timm

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

111 views 2 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you