Trac Import issues with special characters such as umlauts (ü, ö, etc.)
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
Problem
After importing from Trac into any database, special characters such as umlauts are not imported properly in certain fields.
Diagnosis
Diagnostic Steps
- All of your table and database collations are utf-8.
- Import from Trac.
- See "?" instead of your special character in some fields but not others.
Resolution
- As per Setting properties and options on startup, add the -Dfile.encoding tag and set it to utf-8.
- Restart JIRA.
- Reimport your data.