Characters Not Supported by ASCII are Being Displayed as Question Marks
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
Non-English characters typed into JIRA are displayed as question marks, e.g. umlauts ( ä ) or Asian characters ( 要 ).
Cause
Character encoding used by one of the JIRA components is set to use encoding that doesn't support given characters.
Resolution
- Change encoding to
-Dfile.encoding=utf-8
to your application startup parameters. See Setting Properties and Options on Startup. - If the database was not created with the utf8 charset:
- Append to URL
&useUnicode=true&characterEncoding=UTF8
to the database URL in<jira-install>/conf/server.xml
. - Recreate a new database with correct encoding
CREATE DATABASE jiratest CHARACTER SET utf8;
- Point
server.xml
's database configuration to the new database - Create an XML backup
- Restart JIRA
- Import the XML backup into your new database
- Append to URL